开发者

Apache POI. Setup data filters in Excel

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 wit开发者_运维问答h 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


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

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜