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

Declaration

XlCellRange AutoFilterRange { get; set; }

Property Value

Type Description
XlCellRange

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

Remarks

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.

XlExport_EnableAutoFilter

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

Note

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