Hi, I successfully run your code on my computer using POI 3.8. Can you please send me your source .xls file to which you add image?
Regards, Evgeniy On Mon, Jul 30, 2012 at 9:07 AM, MobileAutomator <[email protected]>wrote: > Hi, > > I am trying to insert a image to a and existing work book. Below is the > code > for that > > public void insertPicture(String file, String Image) throws > Exception{ > > FileInputStream myInput = new FileInputStream(file); > POIFSFileSystem myFileSystem = new > POIFSFileSystem(myInput); > > HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem); > HSSFSheet mySheet; > > > mySheet = > myWorkBook.getSheetAt(myWorkBook.getNumberOfSheets()-1); > > int rownum = mySheet.getLastRowNum()+1; > > HSSFRow r1 = mySheet.createRow(rownum); > > System.out.println("Row Number : " + rownum); > > FileInputStream fis=new FileInputStream(Image); > ByteArrayOutputStream img_bytes=new > ByteArrayOutputStream(); > int b; > while((b=fis.read())!=-1) > img_bytes.write(b); > fis.close(); > > > HSSFClientAnchor anchor = new > HSSFClientAnchor(0,0,0,0,(short)1,rownum,(short)2,++rownum); > > int > > index=myWorkBook.addPicture(img_bytes.toByteArray(),HSSFWorkbook.PICTURE_TYPE_PNG); > > HSSFPatriarch patriarch=mySheet.createDrawingPatriarch(); > patriarch.createPicture(anchor,index); > anchor.setAnchorType(2); > > try{ > FileOutputStream out = new FileOutputStream(file); > myWorkBook.write(out); > out.close(); > }catch(Exception e){ > e.printStackTrace(); > } > > } > > and i get the below exception. > > java.lang.IndexOutOfBoundsException: Index: 6, Size: 1 > at java.util.ArrayList.RangeCheck(ArrayList.java:547) > at java.util.ArrayList.get(ArrayList.java:322) > at > > org.apache.poi.hssf.model.DrawingManager2.getDrawingGroup(DrawingManager2.java:125) > at > > org.apache.poi.hssf.model.DrawingManager2.allocateShapeId(DrawingManager2.java:71) > at > > org.apache.poi.hssf.record.EscherAggregate.convertPatriarch(EscherAggregate.java:936) > at > > org.apache.poi.hssf.record.EscherAggregate.convertUserModelToRecords(EscherAggregate.java:769) > at > > org.apache.poi.hssf.record.EscherAggregate.getRecordSize(EscherAggregate.java:507) > at > > org.apache.poi.hssf.model.InternalSheet.preSerialize(InternalSheet.java:1565) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1289) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1209) > at > com.excel.ReadWrite.ExcelWrite.insertPicture(ExcelWrite.java:590) > at com.excel.ReadWrite.ExcelWrite.main(ExcelWrite.java:998) > > > I guess the index 6 is the number of sheets in the workbook as i have 6 > sheets in my workbook. > > > I am using poi- 3.8 > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Inserting-Image-To-a-existing-workbook-tp5710574.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
