开发者

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

开发者 https://www.devze.com 2023-01-15 12:33 出处:网络
Last开发者_如何学JAVA time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest.Apache POI does support AutoFilter, though

Last开发者_如何学JAVA time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest.


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

0

精彩评论

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

关注公众号