You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Thomas Fromm <tf...@tfromm.com> on 2004/07/21 14:31:47 UTC

java.lang.ArrayIndexOutOfBoundsException when loading .xls

Hi,

few weeks ago there was a similar problem under the 
thread "poi newbie question".
Like there i've got also the exception listed at the bottom.

I directly load a .xls Document from filesystem. Its the first document i've 
got, where this problem occurs. I use poi in version 2.5-final.

The reason for the problem are filters. If there are e.g. Auto Filter in this 
spreadsheet, i can't read it anymore with poi.
(Data -> Filter -> Auto Filter )

Exists there a solution for this problem?

kind regards,
Thomas


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:274)
        at 
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:224)
        at 
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
        at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:165)
        at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:132)
        at 
com.inubit.ibis.plugins.IBISXLSXMLAdapter.execute(IBISXLSXMLAdapter.java:77)
        at 
com.inubit.ibis.plugins.IBISXLSXMLAdapter.main(IBISXLSXMLAdapter.java:610)
Caused by: java.lang.ArrayIndexOutOfBoundsException
        at java.lang.System.arraycopy(Native Method)
        at 
org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62)
        at 
org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57)
        at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)
        at org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
        at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
        at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61)
        ... 10 more
com.inubit.ibis.utils.InubitException: Unable to construct record instance, 
the following exception occured: null

-- 

inubit -   the integration experts        Web: http://www.inubit.com
Thomas Fromm, inubit AG                      mailto:thomas.fromm@inubit.com
L�tzowstra�e 105-106, D-10785 Berlin
Freecall 0800-GoInUBIT, Tel +49(30)726112-135, Fax -100

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

Re: AW: java.lang.ArrayIndexOutOfBoundsException when loading .xls

Posted by Avik Sengupta <av...@itellix.com>.
archive.apache.org contains old releases. 

Check the mailing list archives for the complete url, or navigate from
http://archive.apache.org



On Wed, 2004-07-21 at 19:10, Thomas Fromm wrote:
> Karl-Heinz,
> 
> > Test it with POI 2.0. E.g. using lists 2.5 didn't work and 2.0 did.
> 
> Thanks for the advice, it works with 2.0. :-)
> 
> I just found 2.0 RC2, exists anywhere a final at one of the mirror sites?
> 
> regards,
> Thomas


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

Re: AW: java.lang.ArrayIndexOutOfBoundsException when loading .xls

Posted by Thomas Fromm <tf...@tfromm.com>.
Karl-Heinz,

> Test it with POI 2.0. E.g. using lists 2.5 didn't work and 2.0 did.

Thanks for the advice, it works with 2.0. :-)

I just found 2.0 RC2, exists anywhere a final at one of the mirror sites?

regards,
Thomas

-- 

inubit -   the integration experts        Web: http://www.inubit.com
Thomas Fromm, inubit AG                      mailto:thomas.fromm@inubit.com
L�tzowstra�e 105-106, D-10785 Berlin
Freecall 0800-GoInUBIT, Tel +49(30)726112-135, Fax -100

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

AW: java.lang.ArrayIndexOutOfBoundsException when loading .xls

Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Thomas.

Test it with POI 2.0. E.g. using lists 2.5 didn't work and 2.0 did.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Thomas Fromm [mailto:tf@tfromm.com] 
Gesendet: Mittwoch, 21. Juli 2004 14:32
An: POI Users List
Betreff: java.lang.ArrayIndexOutOfBoundsException when loading .xls

Hi,

few weeks ago there was a similar problem under the 
thread "poi newbie question".
Like there i've got also the exception listed at the bottom.

I directly load a .xls Document from filesystem. Its the first document
i've 
got, where this problem occurs. I use poi in version 2.5-final.

The reason for the problem are filters. If there are e.g. Auto Filter in
this 
spreadsheet, i can't read it anymore with poi.
(Data -> Filter -> Auto Filter )

Exists there a solution for this problem?

kind regards,
Thomas


java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
        at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
        at 
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java
:224)
        at 
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav
a:160)
        at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:165)
        at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:132)
        at 
com.inubit.ibis.plugins.IBISXLSXMLAdapter.execute(IBISXLSXMLAdapter.java
:77)
        at 
com.inubit.ibis.plugins.IBISXLSXMLAdapter.main(IBISXLSXMLAdapter.java:61
0)
Caused by: java.lang.ArrayIndexOutOfBoundsException
        at java.lang.System.arraycopy(Native Method)
        at 
org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62)
        at 
org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57)
        at
org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)
        at org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
        at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
        at
org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61)
        ... 10 more
com.inubit.ibis.utils.InubitException: Unable to construct record
instance, 
the following exception occured: null

-- 

inubit -   the integration experts        Web: http://www.inubit.com
Thomas Fromm, inubit AG
mailto:thomas.fromm@inubit.com
Ltzowstra e 105-106, D-10785 Berlin
Freecall 0800-GoInUBIT, Tel +49(30)726112-135, Fax -100

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




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