AutoFilter

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

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();
            sheet.Name = "Data";

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

            CustomFilter customFilter = new CustomFilter();
            customFilter.FilterOperator = FilterOperator.GreaterThan;
            customFilter.Value = "80";

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

            FilterColumn filterColumn = new FilterColumn();
            filterColumn.ColumnID = 1;
            filterColumn.CustomFilters = customFilters;

            AutoFilter autoFilter = new AutoFilter("A1:B5");
            autoFilter.FilterColumns.Add(filterColumn);

            sheet.AutoFilter = autoFilter;

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet As New Worksheet()
        sheet.Name = "Data"

        sheet("A1") = New Cell("Name")
        sheet("B1") = New Cell("Score")
        sheet("A2") = New Cell("Alice")
        sheet("B2") = New Cell(92)
        sheet("A3") = New Cell("Bob")
        sheet("B3") = New Cell(78)
        sheet("A4") = New Cell("Charlie")
        sheet("B4") = New Cell(85)
        sheet("A5") = New Cell("Diana")
        sheet("B5") = New Cell(70)

        Dim customFilter As New CustomFilter()
        customFilter.FilterOperator = FilterOperator.GreaterThan
        customFilter.Value = "80"

        Dim customFilters As New CustomFilters()
        customFilters.First = customFilter

        Dim filterColumn As New FilterColumn()
        filterColumn.ColumnID = 1
        filterColumn.CustomFilters = customFilters

        Dim autoFilter As New AutoFilter("A1:B5")
        autoFilter.FilterColumns.Add(filterColumn)

        sheet.AutoFilter = autoFilter

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > AutoFilter

Need help? Ask our developers: