https://bz.apache.org/bugzilla/show_bug.cgi?id=61397

            Bug ID: 61397
           Summary: Unable to read excel using HSSFWorkbook in poi 3.8 but
                    works fine in 3.0, I cannot downgrade the version.
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: manju.gane...@gmail.com
  Target Milestone: ---

I am using an excel of version Microsoft Excel 97-2003 Worksheet (.xls). I am
trying to read the excel in java using following code. I am using poi 3.8
version
 fis = new FileInputStream(filename);
 HSSFWorkbook workbook = new HSSFWorkbook(fis);

I am getting the following error. 
Exception in thread "main" java.lang.RuntimeException: Unexpected record type
(org.apache.poi.hssf.record.ColumnInfoRecord)
        at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.<init>(RowRecordsAggregate.java:107)
        at
org.apache.poi.hssf.model.InternalSheet.<init>(InternalSheet.java:208)
        at
org.apache.poi.hssf.model.InternalSheet.createSheet(InternalSheet.java:163)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:296)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:248)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:192)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:327)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:308)
        at com.wona.ExcelExtractService.main(ExcelExtractService.java:28)


It works fine in poi 3.0 version, but i cannot downgrade to an older version.

On opening in excel and resaving it in different name the new excel works fine.
I cannot resave the excel and use all the time. Need a fix for it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to