GrapeCity.Documents.Excel.IAutoFilter.ApplyFilter

ApplyFilter Method

ApplyFilter()

Applies the specified autoFilter object.

Call this method to apply the current filter settings to the autofiltered range.

Declaration

void ApplyFilter()

Sub ApplyFilter()

Examples

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