Auto Filter using POI

[Mohammed Yousuff]

Hi,

I want to update a data to a excel sheet,i used POI to update the data in the new worksheet.

It updated correcctly, when i added Auto Filter option in the excell sheet it throws the following errors.

do you guys any thoughts in this.

Thanks a lot for your help in Advance .

----

 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: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 com.passion4java.poi.Tester.main(Tester.java:21)
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)
... 9 more
Exception in thread "main" 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 com.passion4java.poi.Tester.main(Tester.java:21)
   

[Abdul Kader]

guys do your have any thought on this ?

[Anubhav Anand]

This bug had been reported to apache for POI 2.5 and was marked as resolved but, POI 3.0 also reports same problem.

Well, I think this AutoFilter problem is not resolved properly.

[babu javafx]

This Problem is resolved in POI 3.5, so you can use poi3.5 for AutoFilter option.

But for large size files, POI3.5 is giving some other problems.

Any Suggestions from you guyz


babu

[Rob Spoor]

Moving to other open source projects.

[Ulf Dittmer]

Hello "babu javafx"-

Welcome to JavaRanch.

On your way in you may have missed that we have a policy on screen names here at JavaRanch. Basically, it must consist of a first name, a space, and a last name, and not be obviously fictitious. Since yours does not conform with it, please take a moment to change it, which you can do using the "My Profile" link at the top of the page.

But for large size files, POI3.5 is giving some other problems.
Any Suggestions from you guyz

What problems are those? TellTheDetails

Also, please leave out the colored fonts. They only serve to make your post harder to read.