Apache POI. Setup data filters in Excel

Question

I have been using Apache POI for quite sometime and it works great but I am not able to find a reliable answer about filter support in the library.

For reference, I mean the filter option available in data tab in excel which allows you to show all unique values of a column as a combo box in the header of the Column.

I know there is already a question about it generate excel in java where this question was asked.

And I see that Apache POI people checked in something recently for this https://issues.apache.org/bugzilla/show_bug.cgi?id=35125

Is there anyone who has used POI new version to try filter option?

As waiting for the final release of POI with this feature may not be possible for us, can anyone point out other Excel Java API which allow this option (JExcel does not as far as I found out). I do see many websites allowing export to excel with filtering available. If there is no good API to provide it, is there any other way or post processing on excel which i can do to add this option

Sorry for the repeated question, but I could not see any other way to resolve my issue other than approaching stackoverflow community

Answer 1

It's already enabled in Apache POI 3.7. How? take a look...

sheet.setAutoFilter(CellRangeAddress.valueOf("A1:C200"));