XlFilterColumn.FilterCriteria Property

Gets or sets the filter criteria that should be applied to the current column.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public IXlFilterCriteria FilterCriteria { get; set; }

VB.NET

Public Property FilterCriteria As IXlFilterCriteria

Property Value

Type	Description
IXlFilterCriteria	An object implementing the IXlFilterCriteria interface.

Remarks

You can also use the XlFilterColumn constructor with the filterCriteria parameter to specify the filter criteria that should be applied to the current column.

The following types of filters are available:

• XlCustomFilters - a custom filter that uses filter values and comparison operators to construct the filter expression;
• XlDynamicFilter - a dynamic filter;
• XlTop10Filter - a "Top 10" filter that displays top/bottom ranked values;
• XlValuesFilter - filters by a list of cell values or date and time values;
• XlColorFilter - filters by cell color or font color.

Create an instance of the required class specifying the filter type you wish to apply and assign it to the FilterCriteria property to define the column’s filter criteria.

For examples on how to filter data in a worksheet using the Excel Export Library, refer to the Filtering article.