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.v19.1.Core.dll
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 |
|---|---|
| XlCustomFilters | A custom filter that uses filter values and comparison operators to construct the filter expression. |
| XlDynamicFilter | A dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average. |
| XlTop10Filter | A "Top 10" filter that displays top/bottom ranked values. |
| XlValuesFilter | A filter by a list of cell values or date and time values. |
| XlColorFilter | 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.