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("Strings").CellBelow().SetValue("B").CellBelow().SetValue("C").CellBelow().SetValue("C").CellBelow().SetValue("E").CellBelow().SetValue("A").CellBelow().SetValue("D");// Add filtersws.RangeUsed().SetAutoFilter().Column(1).Between("B","D");// Sort the filtered listws.AutoFilter.Sort(1,XLSortOrder.Descending);wb.SaveAs("AutoFilter.xlsx");