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

C#

SheetAutoFilter AutoFilter { get; }

VB.NET

ReadOnly Property AutoFilter As SheetAutoFilter

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

AutoFilterActions.vb

' 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"})

AutoFilterActions.cs

// Enable filtering for the specified cell range.
Range 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"});