IXlFilterCriteria Interface
A base interface for classes that specify the filter criteria applied to worksheet and table columns.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
#Declaration
#Related API Members
The following members return IXlFilterCriteria objects:
#Remarks
The table below lists classes that implement the IXlFilterCriteria interface and specify the filter criteria to apply to a column in a cell range or table.
Class | Description |
---|---|
Xl |
A custom filter that uses filter values and comparison operators to construct the filter expression. |
Xl |
A dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average. |
Xl |
A "Top 10" filter that displays top/bottom ranked values. |
Xl |
A filter by a list of cell values or date and time values. |
Xl |
A filter 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 XlFilterColumn.FilterCriteria or IXlTableColumn.FilterCriteria property to define the filter criteria for a filter range or table column, respectively.
For examples on how to filter data in a worksheet using the Excel Export Library, refer to the Filtering article.