Hi Avik, Thanks a lot for your quick response.. I have changed the cell encoding to UTF-16 ( Though the values i am setting for any of the cells doesn't have any Unicode Strings..) .
But still i am getting the same Error. The POI version i am using is jakarta-poi-1.5.0-dev-20020415.jar . Now i am trying to test my app with RC2 Regards Sateesh -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:35 PM To: POI Users List Subject: RE: Exception =java.lang.ArrayIndexOutOfBoundsException: 112 OK, there seems to be something wrong in one the strings that you set in the sheet. Do the characters in your string have the High-byte populated (ie, are they unicode strings? or are they all US-ASCII). Try to set the cell encoding to UTF-16 The best way to figure this is to debug into the code and find out which exact string has a problem. Finally, which version of POI are you using? You should be using RC2. its the least buggy! Regards - Avik On Wed, 2004-01-21 at 18:16, Kommineni, Sateesh (GE Consumer & Industrial) wrote: > Hi All, > > This is the Exception i am getting .. > Pls let me know your thoughts.. > > Thanks a lot for all your help.. > > =================================================================================================== > > Excep=java.lang.ArrayIndexOutOfBoundsException: 112 > [4/21/03 18:12:47:047 GMT+05:30] 354f8540 SystemErr R > java.lang.ArrayIndexOutOfBoundsException: 112 > [4/21/03 18:12:47:047 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.util.StringUtil.putUncompressedUnicode(StringUtil.java:175) > [4/21/03 18:12:47:047 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.record.UnicodeString.serialize(UnicodeString.java:299) > [4/21/03 18:12:47:047 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.record.Record.serialize(Record.java:168) > [4/21/03 18:12:47:047 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.record.SSTRecord.serialize(SSTRecord.java:541) > [4/21/03 18:12:47:097 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.model.Workbook.serialize(Workbook.java:664) > [4/21/03 18:12:47:097 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:505) > [4/21/03 18:12:47:097 GMT+05:30] 354f8540 SystemErr R at > org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:465) > [4/21/03 18:12:47:097 GMT+05:30] 354f8540 SystemErr R at > com.geindustrials.qms.util.GEISQMSExcelGenerator.generateWorkBook(GEISQMSExcelGenerator.java:177) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.geindustrials.qms.actions.supplier.DownloadExcelAction.perform(DownloadExcelAction.java:80) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.geindustrials.framework.action.RequestProcessor.process(RequestProcessor.java:115) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.geindustrials.framework.action.ActionServlet.process(ActionServlet.java:39) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.geindustrials.framework.action.ActionServlet.doGet(ActionServlet.java:23) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) > [4/21/03 18:12:47:107 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331) > [4/21/03 18:12:47:117 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) > [4/21/03 18:12:47:127 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432) > [4/21/03 18:12:47:127 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343) > [4/21/03 18:12:47:127 GMT+05:30] 354f8540 SystemErr R at > com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592) > > -----Original Message----- > From: Robert Lowe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 6:03 PM > To: POI Users List > Subject: RE: Exception =java.lang.ArrayIndexOutOfBoundsException: 112 > > > Sateesh, I think you should modify your code to show the whole stack trace. > I'm sure you'll get much better help if you can provide a full stack trace. > > > > Best regards, > > Robert Lowe > http://RMLowe.com/ > > > > -----Original Message----- > From: Kommineni, Sateesh (GE Consumer & Industrial) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 8:26 PM > To: POI Users List > Subject: RE: Exception =java.lang.ArrayIndexOutOfBoundsException: 112 > > > Hi, > > I am getting the following Exception.. > java.lang.ArrayIndexOutOfBoundsException: 112 > In my earlier mail i mentioned just 112 , which i got by printing the > getMessage() on exception. Sorry for just mentioning 112 > > Why i am getting ArrayIndexOutofBoundsException when i am trying to write > the data to a ServletOutputStream object.. > > Shall i need to specify the byte size i am going to write to the stream?? > > Pls let me know your thoughts.. > > -Sateesh > > > > -----Original Message----- > From: Avik Sengupta [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 5:37 PM > To: POI Users List > Subject: Re: Exception = 112 > > > > What does the 112 mean ?? > > You tell me. You are eating up the exception. > > On Wed, 2004-01-21 at 16:53, Kommineni, Sateesh (GE Consumer & > Industrial) wrote: > > Hi All, > > > > I am trying to modify an existing Excel File using the POI. > > > > The Environment details are > > > > WSAD5.0 , POI = jakarta-poi-1.5.0-dev-20020415 > > > > When i try to generate a File using the below given code...i am getting > the Error: > > .... > > [4/21/03 16:30:59:364 GMT+05:30] 26adc544 SystemOut O Created a Row > .. > > [4/21/03 16:30:59:364 GMT+05:30] 26adc544 SystemOut O About to write > the > > [4/21/03 16:30:59:414 GMT+05:30] 26adc544 SystemOut O Excpe in > generateWorkBook()=112 > > > > What does the 112 mean ?? > > > > > ============================================================================ > ============ > > public void generateWorkBook(OutputStream out, ArrayList ctqDetails)throws > Exception{ > > > > System.out.println(" Here in generateWorkBook() and out="+out); > > GEISQMSCtqBeanEx ctqBeanEx = null; > > HSSFWorkbook wb = null; > > HSSFRow row = null; > > HSSFCell cell = null; > > FileOutputStream fout= null; > > POIFSFileSystem fs =null; > > String oldPartNum =""; > > try{ > > if(path==null) > > throw new Exception("Path is Not set Error.."); > > fs = new POIFSFileSystem(new FileInputStream(path+FILE_NAME)); > > wb = new HSSFWorkbook(fs); > > HSSFSheet sheet = wb.getSheet("Ctq Details"); > > System.out.println("No.of Sheets > > After="+wb.getNumberOfSheets()); > > int noOfCtqs = ctqDetails.size(); > > System.out.println("No.Of CTQs="+noOfCtqs); > > for(int i=0;i<noOfCtqs;i++){ > > ctqBeanEx = (CtqBeanEx) ctqDetails.get(i); > > System.out.println("Part Number"+(i+1)+" > ="+ctqBeanEx.getPartNumber()+" Ctq Number="+ctqBeanEx.getCtqNumber()); > > > > if(oldPartNum==null) > > oldPartNum = ctqBeanEx.getPartNumber(); > > row = sheet.createRow((short)i); > > System.out.println("Old Part="+oldPartNum); > > if(oldPartNum!=null && > > !oldPartNum.equals(ctqBeanEx.getPartNumber())){ > > // Column 0 is Part Number > > cell = row.createCell((short)0); > > cell.setCellValue(ctqBeanEx.getPartNumber()); > > cell.setCellType(HSSFCell.CELL_TYPE_STRING); > > > > } > > // Column 1 is CTQ Number > > cell = row.createCell((short)1); > > > > cell.setCellValue(Integer.parseInt(ctqBeanEx.getCtqNumber())); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > // Column 2 is SubGroup Size > > cell = row.createCell((short)2); > > cell.setCellValue(ctqBeanEx.getSubGroupSize()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > // Column 3 is Ctq Specification > > cell = row.createCell((short)3); > > cell.setCellValue(ctqBeanEx.getCtqSpec()); > > cell.setCellType(HSSFCell.CELL_TYPE_STRING); > > > > // Column 4 is Unit Of Measure > > cell = row.createCell((short)4); > > cell.setCellValue(ctqBeanEx.getUom()); > > cell.setCellType(HSSFCell.CELL_TYPE_STRING); > > > > > > > > // Column 5 is USL > > cell = row.createCell((short)5); > > cell.setCellValue(ctqBeanEx.getUsl()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > // Column 6 is LSL > > cell = row.createCell((short)6); > > cell.setCellValue(ctqBeanEx.getLsl()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > // Column 7 is Nominal > > cell = row.createCell((short)7); > > cell.setCellValue(ctqBeanEx.getNominal()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > // Column 8 is UAL > > /* > > cell = row.createCell((short)8); > > cell.setCellValue(ctqBeanEx.getUal()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > > > > > > > // Column 9 is LAL > > cell = row.createCell((short)9); > > cell.setCellValue(ctqBeanEx.getLal()); > > cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); > > */ > > System.out.println("Created a Row .."); > > oldPartNum = ctqBeanEx.getPartNumber(); > > > > } > > System.out.println("About to write the "); > > int index = FILE_NAME.indexOf('.'); > > fout=new > > FileOutputStream(path+FILE_NAME.substring(0,index)+"1.xls"); > > wb.write(fout); > > System.out.println("Done with fout"); > > if(out!=null){ > > System.out.println("About to write the data to the Servlet > OutputStream"); > > wb.write(out); > > } > > > > System.out.println("After constructing the Excel Sheet"); > > } > > catch(Exception e){ > > System.out.println("Excpe in generateWorkBook()="+e.getMessage()); > > throw e; > > } > > finally{ > > try{ > > fout.close(); > > } > > catch(Exception e){ > > throw new Exception("Unable to close the > FileOutputStream="+e.getMessage()); > > } > > } > > > > } > > > > > ============================================================================ > ============== > > > > Thanks in Advance.. > > Sateesh > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
