Re: Removing sheets from workbook (poi 3.8)

[Jon Svede]

How is the workbook being created?  Is the workbook representing an existing 
file or are you creating?

Jon






________________________________
From: Hamza Abdelkebir <hamza.abdelke...@gmail.com>
To: POI Users List <user@poi.apache.org>
Sent: Fri, June 24, 2011 1:54:45 AM
Subject: Removing sheets from workbook (poi 3.8)

Hi all,

I'm having this exception when trying to remove the last 4 sheets from a
workbook :

Exception in thread "main" java.lang.IllegalArgumentException: calculated
end index (484283) is out of allowable range (484279..484282)
at
org.apache.poi.util.LittleEndianByteArrayOutputStream.<init>(LittleEndianByteArrayOutputStream.java:41)

at
org.apache.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:38)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1246)

at
org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1292)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1191)
at pb.odm.ODM.saveData(ODM.java:1212)
at pb.odm.ODM.buildODM(ODM.java:195)
at pb.odm.ODM.run(ODM.java:1222)
at pb.odm.Main.main(Main.java:11)


Using this method :

private void removeExtraSheets(){
int i=0;
        while(i<3){
             destwb.removeSheetAt(destwb.getNumberOfSheets()-1);
     i++;
         }
}

Any ideas ?

Thanks,
Hamza