Use AutoFilter to Filter Excel Data - Java

Use_AutoFilter_to_Filter_Excel_Data.java

// Directory path for input and output Excel files.
String dirPath = "D:/Download/";

// Load the input Excel file containing the sample data.
Workbook wb = new Workbook(dirPath + "sampleUseAutoFilterToFilterExcelData.xlsx");

// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);

// Apply auto filter to the range.
ws.getAutoFilter().setRange("D3:G3");

// Add filter to first column (i.e. Vehicle) inside the range - Criteria --> Bike
ws.getAutoFilter().addFilter(0, "Bike");

// Add filter to first column (i.e. Vehicle) inside the range - Criteria --> Car
ws.getAutoFilter().addFilter(0, "Car");

// Refresh the auto filter.
ws.getAutoFilter().refresh();

// Add filter to second column (i.e. Color) inside the range - Criteria --> Green
ws.getAutoFilter().addFilter(1, "Green");

// Add filter to second column (i.e. Color) inside the range - Criteria --> Blue
ws.getAutoFilter().addFilter(1, "Blue");

// Refresh the auto filter.
ws.getAutoFilter().refresh();

// Save the workbook in XLSX format. 
// You can also save it to XLS or other formats.
wb.save(dirPath + "outputUseAutoFilterToFilterExcelData.xlsx", SaveFormat.XLSX);