GrapeCity.Documents.Excel.IWorksheet.AutoFilter

AutoFilter Property

AutoFilter

Gets the IAutoFilter object for the worksheet.

The returned object provides access to the filter range, filters, and sort settings for the worksheet's AutoFilter. Returns null if AutoFilter is not enabled on the worksheet.

Declaration

IAutoFilter AutoFilter { get; }

ReadOnly Property AutoFilter As IAutoFilter

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200}
};
worksheet.Range["A1:B3"].AutoFilter();
IAutoFilter autoFilter = worksheet.AutoFilter;
IRange filterRange = autoFilter.Range;