XlFilterType Enum

Lists types of filters available for the AutoFilter functionality.

Namespace : DevExpress.Export.Xl

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

NuGet Package : DevExpress.Printing.Core

Declaration

• C#
• VB.NET

public enum XlFilterType

Public Enum XlFilterType

Members

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.

See Also

DevExpress.Export.Xl Namespace