You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by sunil tiwari <st...@imcindia.net> on 2008/03/12 10:43:58 UTC

error while reading excel file through poi 3.0.2 Final

Hi 

I am using poi 3.0.2 Final .jar ,

While reading an excel file which has lot's of drop down type of fields it
is giving exception bellow

 

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:11
7)

      at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:207)

      at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:148)

      at com.hedder.main(hedder.java:29)

Caused by: java.lang.reflect.InvocationTargetException

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187
)

      ... 4 more

Caused by: java.lang.ArrayIndexOutOfBoundsException

      at
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInput
Stream.java:132)

      at
org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.jav
a:152)

      at
org.apache.poi.hssf.util.HSSFCellRangeAddress.fillFields(HSSFCellRangeAddres
s.java:77)

      at
org.apache.poi.hssf.util.HSSFCellRangeAddress.<init>(HSSFCellRangeAddress.ja
va: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)

      ... 9 more

 

Can anybody give me solution for it

We are shaped and fashioned by what we love.

Regards,

sunil tiwari

Re: error while reading excel file through poi 3.0.2 Final

Posted by Nick Burch <ni...@torchbox.com>.
On Thu, 13 Mar 2008, Yury Batrakov wrote:
>> Could you open a new bug on bugzilla, and upload your file? It looks like
>>  we're not handling all possible cases for DVRecord
>
> Searching through bugzilla I'm not sure that Sunil has done this, so I
> found the file to reproduce this bug and submitted it. See
> https://issues.apache.org/bugzilla/show_bug.cgi?id=44593 for details

Should hopefully now be fixed in svn trunk

Nick

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

Re: error while reading excel file through poi 3.0.2 Final

Posted by Yury Batrakov <ba...@gmail.com>.
> Could you open a new bug on bugzilla, and upload your file? It looks like
>  we're not handling all possible cases for DVRecord
>

Searching through bugzilla I'm not sure that Sunil has done this, so I
found the file to reproduce this bug and submitted it. See
https://issues.apache.org/bugzilla/show_bug.cgi?id=44593 for details

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

Re: error while reading excel file through poi 3.0.2 Final

Posted by Nick Burch <ni...@torchbox.com>.
On Wed, 12 Mar 2008, sunil tiwari wrote:
> I am using poi 3.0.2 Final .jar ,
>
> While reading an excel file which has lot's of drop down type of fields it
> is giving exception bellow

Could you open a new bug on bugzilla, and upload your file? It looks like 
we're not handling all possible cases for DVRecord

Nick

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