Skip to main content

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.1.Core.dll

NuGet Package: DevExpress.Printing.Core


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