[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IFilters.Item

this Property

this[int]

Gets the filter by index.

Use this indexer to retrieve a filter from the collection of filters in the current auto-filter range.

Declaration
IFilter this[int index] { get; }
ReadOnly Default Property Item(index As Integer) As IFilter
Parameters
Type Name Description
int index

The index of the filter to retrieve.

Examples
worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200},
    {"C", 100}
};
worksheet.Range["A1:B4"].AutoFilter(1, "100");
IFilter filter = worksheet.AutoFilter.Filters[1];