The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Worksheet.AutoFilter Property

Provides access to an object that contains options to filter data in a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

SheetAutoFilter AutoFilter { get; }
ReadOnly Property AutoFilter As SheetAutoFilter
SheetAutoFilter AutoFilter { get; }
ReadOnly Property AutoFilter As SheetAutoFilter
SheetAutoFilter AutoFilter { get; }
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.

Property Value

Type Description
SheetAutoFilter

A SheetAutoFilter object that implements the filtering functionality for a cell range in a worksheet.

Property Value

Type Description
SheetAutoFilter

A SheetAutoFilter object that implements the filtering functionality for a cell range in a worksheet.

Examples

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.

' Enable filtering for the specified cell range.
Dim range As CellRange = 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