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]
