Apache POI Setup data filters in Excel

Question

I've been using Apache POI for a while now, and it's amazing. However, I can't seem to locate a trustworthy response regarding filter support in the library. As a point of reference, I'm referring to the filter option in Excel's data tab that enables you to display all distinct values from a column as a combo box in the column header.

I know there is already a question about it generating 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 the filter option?

Answer 1

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

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