Click or drag to resize

ExcelAutoFilter Methods

The ExcelAutoFilter type exposes the following members.

Methods
 NameDescription
Public methodApplyFilters Applies the filters again after the cell values have changed: the rows of the range that meet the filters of all the columns are shown and the other rows are hidden. The filter methods of this class apply the filters automatically. Filters loaded from an existing workbook that the library cannot evaluate (colors, icons, dates and top 10) leave the rows as they are, as Excel saved them.
Public methodClearAllFilters Removes the filters of all the columns and shows all the rows of the range. The drop-down arrows remain; call RemoveAutoFilter to remove the AutoFilter.
Public methodClearFilter Removes the filter of the specified column and shows again the rows hidden only by it.
Public methodFilterByCondition Shows only the rows whose cell in the specified column meets a condition, for example greater than 100. The filter replaces the previous filter of the column; the filters of the other columns are kept.
Public methodFilterByConditions Shows only the rows whose cell in the specified column meets two conditions joined by And or Or, for example greater than or equal to 10 And less than 20. The filter replaces the previous filter of the column; the filters of the other columns are kept.
Public methodFilterByValues Shows only the rows whose cell in the specified column displays one of the specified values, compared without regard to case. A number or a date is compared by its displayed text, for example "1,250.00". The filter replaces the previous filter of the column; the filters of the other columns are kept. In the Excel 97-2003 format a column can be filtered by at most two values.
Public methodIsFiltered Gets a value indicating if the specified column has a filter.
Top
See Also