Hi, Im trying to get the number and names of the sheets in an XLS file. To do this , i am trying to create an HSSFWorkBook by using the constructor HSSFWorkbook(POIFSFileSystem fs). The exception i am getting is: java.lang.ArrayIndexOutOfBoundsException: 24 at org.apache.poi.hssf.record.MulBlankRecord.getXFAt (MulBlankRecord.java:171) at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:315) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:193) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:207) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:174)
Please attach a small spreadsheet exhibiting this behaviour.
Created attachment 12672 [details] Attaching the spreadsheet exhibiting this behaviour.
Works for me with latest CVS version. Jason
Created attachment 35584 [details] Example file with exception java.lang.ArrayIndexOutOfBoundsException: 2 at org.apache.poi.hssf.record.MulBlankRecord.getXFAt(MulBlankRecord.java:80) at org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.addMultipleBlanks(ValueRecordsAggregate.java:161) at org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.<init>(RowRecordsAggregate.java:93) at org.apache.poi.hssf.model.InternalSheet.<init>(InternalSheet.java:183) at org.apache.poi.hssf.model.InternalSheet.createSheet(InternalSheet.java:122) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:367) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:413) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:394)
The same bug with 3.17-FINAL.