Removing sheets from workbook (poi 3.8)

[Hamza Abdelkebir]

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