corelibraries-devexpress-dot-export-dot-xl-cb0d9592.md
A base interface for classes that specify the filter criteria applied to worksheet and table columns.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public interface IXlFilterCriteria
Public Interface IXlFilterCriteria
The following members return IXlFilterCriteria objects:
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.
See Also