GrapeCity.Documents.Excel.ITable.AutoFilter

AutoFilter Property

AutoFilter

Gets the IAutoFilter for this table.

The returned auto filter represents the filtering settings that apply to the table range.

Declaration

IAutoFilter AutoFilter { get; }

ReadOnly Property AutoFilter As IAutoFilter

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Name", "Value", "Category"},
    {"A", 100, "X"},
    {"B", 200, "Y"},
    {"C", 100, "X"}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:C4"], true);
table.Range.AutoFilter(2, "X");
IAutoFilter autoFilter = table.AutoFilter;
object criteria1 = autoFilter.Filters[2].Criteria1;