GrapeCity.Documents.Excel.IAutoFilter

IAutoFilter Interface

Represents autofiltering for the specified worksheet.

Provides access to the worksheet's AutoFilter state, including the filtered IRange, the IFilters collection for the autofiltered range, and the associated ISort settings. Use this interface to inspect or update an existing worksheet AutoFilter after it has been created.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IAutoFilter

Public Interface IAutoFilter

Examples

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

Properties

Name	Description
FilterMode	Gets whether the worksheet is in the AutoFilter filter mode.
Filters	Gets the IFilters collection that represents all the filters in an autofiltered range.
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.
Sort	Gets the sort column or columns, and sort order for the AutoFilter collection.

Methods

Name	Description
ApplyFilter()	Applies the specified autoFilter object. Call this method to apply the current filter settings to the autofiltered range.
ShowAllData()	Clears the applied filter criteria and displays all data in the current AutoFilter range. Makes all rows in the current AutoFilter range visible again by clearing the applied filter criteria.

Name

Description

ApplyFilter()

Applies the specified autoFilter object.

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

ShowAllData()

Clears the applied filter criteria and displays all data in the current AutoFilter range.

Makes all rows in the current AutoFilter range visible again by clearing the applied filter criteria.