XlFilterType Enum

Lists types of filters available for the AutoFilter functionality.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlFilterType

VB.NET

Public Enum XlFilterType

Members

Name	Description
Color	Specifies the filter by color.
Custom	Specifies the custom filter based on a comparison operator.
Dynamic	Specifies the dynamic filter.
Values	Specifies the filter by values and date intervals.
Icon	Specifies the filter by conditional formatting icons.
Top10	Specifies the "Top 10" filter.

Related API Members

The following properties accept/return XlFilterType values:

• IXlFilterCriteria.FilterType
• XlColorFilter.FilterType
• XlCustomFilters.FilterType
• XlDynamicFilter.FilterType
• XlTop10Filter.FilterType
• XlValuesFilter.FilterType

Remarks

Use the IXlFilterCriteria.FilterType property to obtain the type of filter applied to a worksheet or table column.