GrapeCity.Documents.Excel.IFilters

IFilters Interface

Represents a collection of IFilter objects that represent all filters in an autofiltered range.

You can obtain this collection from Filters to inspect the filters that belong to the current autofilter range.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IFilters

Public Interface IFilters

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "City"},
    {"Alice", "New York"},
    {"Bob", "Seattle"}
};
worksheet.Range["A1:B3"].AutoFilter();
IFilters filters = worksheet.AutoFilter.Filters;
IFilter filter = filters[0];

Properties

Name	Description
Count	Gets the number of filters in the collection. This property represents the number of IFilter objects in the IFilters collection for the current auto filter range.
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.

Name

Description

Count

Gets the number of filters in the collection.

This property represents the number of IFilter objects in the IFilters collection for the current auto filter range.

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.