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]
