AutoFilter

The following example shows you how to apply an auto filter to a worksheet range and set a custom filter condition.

import com.independentsoft.office.spreadsheet.AutoFilter;
import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.CustomFilter;
import com.independentsoft.office.spreadsheet.CustomFilters;
import com.independentsoft.office.spreadsheet.FilterColumn;
import com.independentsoft.office.spreadsheet.FilterOperator;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();
            sheet.setName("Data");

            sheet.set("A1", new Cell("Name"));
            sheet.set("B1", new Cell("Score"));
            sheet.set("A2", new Cell("Alice"));
            sheet.set("B2", new Cell(92));
            sheet.set("A3", new Cell("Bob"));
            sheet.set("B3", new Cell(78));
            sheet.set("A4", new Cell("Charlie"));
            sheet.set("B4", new Cell(85));
            sheet.set("A5", new Cell("Diana"));
            sheet.set("B5", new Cell(70));

            CustomFilter customFilter = new CustomFilter();
            customFilter.setFilterOperator(FilterOperator.GREATER_THAN);
            customFilter.setValue("80");

            CustomFilters customFilters = new CustomFilters();
            customFilters.setFirst(customFilter);

            FilterColumn filterColumn = new FilterColumn();
            filterColumn.setColumnID(1);
            filterColumn.setCustomFilters(customFilters);

            AutoFilter autoFilter = new AutoFilter("A1:B5");
            autoFilter.getFilterColumns().add(filterColumn);

            sheet.setAutoFilter(autoFilter);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > AutoFilter

Need help? Ask our developers: