File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Auto Filter using POI

 
Mohammed Yousuff
Ranch Hand
Posts: 198
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 .

----



 
Abdul Kader
Ranch Hand
Posts: 115
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
guys do your have any thought on this ?
 
Anubhav Anand
Ranch Hand
Posts: 341
Firefox Browser Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20369
44
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to other open source projects.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic