This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Auto Filter using POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Auto Filter using POI" Watch "Auto Filter using POI" New topic

Auto Filter using POI

Mohammed Yousuff
Ranch Hand

Joined: Oct 17, 2007
Posts: 198

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 .


My Thoughts :
Try not to become a man of success but rather to become a man of value.
Abdul Kader
Ranch Hand

Joined: Apr 11, 2007
Posts: 115
guys do your have any thought on this ?
Anubhav Anand
Ranch Hand

Joined: May 18, 2007
Posts: 341

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

Joined: Jan 05, 2009
Posts: 3
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

Rob Spoor

Joined: Oct 27, 2005
Posts: 20279

Moving to other open source projects.

How To Ask Questions How To Answer Questions
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
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.
I agree. Here's the link:
subject: Auto Filter using POI
jQuery in Action, 3rd edition