.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

AutoFilterColumn.ApplyFilterCriteria(FilterValue) Method

Filters data by values.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll

Declaration

void ApplyFilterCriteria(
    FilterValue filters
)

Parameters

Name Type Description
filters FilterValue

A FilterValue object containing values to be used in a filter.

Example

This example demonstrates how to use the SheetAutoFilter.Apply method to enable filtering for a cell range and filter data in a 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