Important

This page is obsolete and no longer being actively maintained. Please refer to pageAutoFilter atdocs.closedxml.io for the latest information.

varwb=newXLWorkbook();varws=wb.Worksheets.Add("AutoFilter");// Add a bunch of strings to filterws.Cell("A1").SetValue("Numbers").CellBelow().SetValue(2).CellBelow().SetValue(3).CellBelow().SetValue(3).CellBelow().SetValue(5).CellBelow().SetValue(1).CellBelow().SetValue(4);// Add filtersws.RangeUsed().SetAutoFilter().Column(1).AddFilter(3).AddFilter(1).AddFilter(5);// Sort the filtered listws.AutoFilter.Sort(1);wb.SaveAs("AutoFilter.xlsx");