Apache POI Setup data filters in Excel

0 votes

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?

Oct 21, 2022 in Others by Kithuzzz
• 38,010 points
1,608 views

1 answer to this question.

0 votes

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

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

answered Oct 21, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Formatting Excel Spreadsheet using Apache POI in JAVA

Try this: CellRangeAddress range= new CellRangeAddress(firstrow, lastrow, firstcol, ...READ MORE

answered Oct 27, 2022 in Others by narikkadan
• 63,700 points
1,782 views
0 votes
1 answer

Excel formula gives error when write using Apache-poi library in Java

I tested some sample code. The cell ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 63,700 points
1,518 views
0 votes
1 answer

Cannot detect strikeout data from excel using apache poi

You must first obtain the RichTextString, then ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,700 points
568 views
0 votes
1 answer

How to create page borders using Apache POI in excel files with Java?

Microsoft Excel cannot do this. Libreoffice Calc ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,700 points
811 views
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,700 points
2,906 views
0 votes
1 answer

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,700 points
4,560 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,700 points
2,793 views
0 votes
1 answer
0 votes
1 answer

Apache POI - watermark in Excel - different appearance in Excel and LibreOffice

There is nothing that apache poi could ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,700 points
1,709 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP