GrapeCity.Documents.Excel.IAutoFilter.Range

Range Property

Range

Gets a Range object that represents the range to which the specified autoFilter applies.

Use this property to retrieve the worksheet range currently associated with the autoFilter.

Declaration

IRange Range { get; }

ReadOnly Property Range As IRange

Examples

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