IXlSheet.AutoFilterRange Property

Gets or sets the cell range for which filtering is enabled.

Namespace: DevExpress.Export.Xl

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


XlCellRange AutoFilterRange { get; set; }

Property Value

Type Description

An XlCellRange object specifying a cell range for which the AutoFilter functionality is enabled.


Use the AutoFilterRange property to enable a filtering functionality for the specified cell range.

// Enable filtering for the data range.
sheet.AutoFilterRange = sheet.DataRange;

Once filtering is activated, a drop-down arrow appears on the right side of each column header, as shown in the image below (the workbook is opened in Microsoft® Excel®). Users can click the arrow of the required column and select the filter type they wish to apply.


The following code snippets (auto-collected from DevExpress Examples) contain references to the AutoFilterRange property.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also