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/