You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by es...@asp-as.no on 2005/04/19 15:56:59 UTC
HSSF and Autofilter
Hi
I am developing a report program in Java and I am trying to read a
Excel-workbook from the Java-application.
Some of the cells in the workbook's sheets contains AutoFilter. This
causes the following exception:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown
Source)
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:163)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130)
at excel.WriteWorkbook.writeWorkbook(WriteWorkbook.java:45)
at excel.WriteWorkbook.<init>(WriteWorkbook.java:34)
at excel.WriteWorkbook.main(WriteWorkbook.java:77)
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
org.apache.poi.hssf.record.RecordFormatException: Unable to construct
record instance, the following exception occured: null
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:237)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130)
at excel.WriteWorkbook.writeWorkbook(WriteWorkbook.java:45)
at excel.WriteWorkbook.<init>(WriteWorkbook.java:34)
at excel.WriteWorkbook.main(WriteWorkbook.java:77)
Does'nt POI HSSF support AutoFilter. Can I edit the code somewhere to
ignore the cells that contains autofilter?
/ espen
Re: HSSF and Autofilter
Posted by Oliver Hirschi <oh...@pm-medici.ch>.
<es...@asp-as.no> schrieb im Newsbeitrag
news:OFCA474D55.2BA4FD73-ONC1256FE8.004C378B-C1256FE8.004CBC25@asp-as.no...
> Hi
>
> I am developing a report program in Java and I am trying to read a
> Excel-workbook from the Java-application.
>
> Some of the cells in the workbook's sheets contains AutoFilter. This
> causes the following exception:
> java.lang.reflect.InvocationTargetException
> at
sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown
I had the same problem today. It seems, POI 2.5.1 is buggy in this case.
Use POI 2.0 RC2 and it works well!
Does anybody know, when this bug could be fixed in a stable version to
download?
Regards, Oliver Hirschi
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/