You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/03/13 09:16:03 UTC

DO NOT REPLY [Bug 44593] New: Exception while reading by ExcelExtractor

https://issues.apache.org/bugzilla/show_bug.cgi?id=44593

           Summary: Exception while reading by ExcelExtractor
           Product: POI
           Version: 3.0-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: batrakov@gmail.com


Created an attachment (id=21657)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=21657)
Excel file that causes an exception

I'm using org.apache.poi.hssf.extractor.ExcelExtractor class for reading Excel
files and I've got an exception below. Problem file is zipped and attached, I
tried to minimize it's contents to make it easier to investigate, but I have no
enough Excel knoweledge to figure out what field causes the problem :)

Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
Unable to construct record instance
        at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:199)
        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:117)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:207)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:259)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:240)
        at
org.apache.poi.hssf.extractor.ExcelExtractor.<init>(ExcelExtractor.java:54)
        at
org.apache.poi.hssf.extractor.ExcelExtractor.main(ExcelExtractor.java:66)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187)
        ... 6 more
Caused by: java.lang.ArrayIndexOutOfBoundsException
        at
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:132)
        at
org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.java:152)
        at
org.apache.poi.hssf.util.HSSFCellRangeAddress.fillFields(HSSFCellRangeAddress.java:77)
        at
org.apache.poi.hssf.util.HSSFCellRangeAddress.<init>(HSSFCellRangeAddress.java:65)
        at org.apache.poi.hssf.record.DVRecord.fillFields(DVRecord.java:207)
        at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
        at org.apache.poi.hssf.record.DVRecord.<init>(DVRecord.java:134)
        ... 11 more


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44593] Exception while reading by ExcelExtractor

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44593

--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2009-12-30 17:55:53 UTC ---
Fixed was applied in svn r636756

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44593] Exception while reading by ExcelExtractor

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44593


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Nick Burch <ni...@torchbox.com>  2008-03-13 06:19:44 PST ---
We were running out of data processing the validation rules in one of the
DVRecords

For now, I've tweaked poi to issue a warning in this case, and carry on. Not
sure if we'll then have garbage data validation rules then or not, but at least
your file can be opened fine, and you ought to be able to get your text out

(Fixed in SVN trunk)


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org