tags:

views:

31

answers:

2
+2  Q: 

Is there any Java-Excel library that supports AutoFilter in Excel?

Last time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest.

A: 

You can try SmartXLS For Java,it support auto filter datas.

liya  2010-09-11 08:09:44
Almost all of the questions you've answered on StackOverflow are promoting SmartXLS or JXCell — which are both relatively obscure products for handling Excel documents. Do you work for the company behind them? If so, I think you should disclose that!
gutch  2010-09-11 12:27:13
I am working for SmartXLS.
liya  2010-09-11 13:29:05
+1  A: 

Apache POI does support AutoFilter, though it's fairly recent functionality.

Simply call setAutoFilter() on your worksheet in POI with the cell range you want to filter. See documentation:
http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter%28org.apache.poi.ss.util.CellRangeAddress%29

gutch  2010-09-11 12:18:02

related questions

Java Time Zone is messed up
Eclipse on win64
Automate builds for Java RCP for deployment with JNLP
Why are professors or schools picking Java over C++ to teach to students?
Is there a real benefit of using J#?
Public/Popular Websites using JavaServer Faces
Why can't I use a try block around my super() call?
Accessing post variables using Java Servlets
Personal Linux web server
Is this really widening vs autoboxing?
How can I Java webstart multiple, dependent, native libraries?
Why can't I call toString() on a Java primitive?
How do I use Java to read from a file that is actively being written?
What code analysis tools do you use for your Java projects?
IllegalArgumentException or NullPointerException for a null parameter?
How do I configure and communicate with a serial port?
What is the best way to parse strings in Java
Getting started with a custom JXTA PeerGroup
Creating a custom button in Java
How to get started "writing" a code coverage tool?
Which Build-/Configuration Management Tool?
What is the difference between an int and an Integer in Java/C#?
What is the meaning of the type safety warning in certain Java generics casts?
How would you access Object properties from within an object method?
Converting CSV File to XML in Java