Worksheet.AutoFilter Property
Provides access to an object that contains options to filter data in a worksheet.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
Type | Description |
---|---|
SheetAutoFilter | A SheetAutoFilter object that implements the filtering functionality for a cell range in a worksheet. |
Example
This example demonstrates how to activate the filtering functionality for a range of cells using the SheetAutoFilter.Apply method and filter data in the specified column by an array of values.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832
' Enable filtering for the specified cell range.
Dim range As Range = worksheet("B2:E23")
worksheet.AutoFilter.Apply(range)
' Filter the data in the "Product" column by an array of values.
worksheet.AutoFilter.Columns(1).ApplyFilterCriteria(New CellValue() { "Mozzarella di Giovanni", "Gorgonzola Telino"})
See Also