Class ExcelAutoFilter
Represents an Autofilter for a worksheet or a filter of a table
Inherited Members
Namespace: OfficeOpenXml.Filter
Assembly: EPPlus.dll
Syntax
public class ExcelAutoFilter : XmlHelperProperties
Address
The range of the autofilter Autofilter with address "" or null indicates empty autofilter.
Declaration
public ExcelAddressBase Address { get; }Property Value
| Type | Description |
|---|---|
| ExcelAddressBase |
Columns
The columns to filter
Declaration
public ExcelFilterColumnCollection Columns { get; }Property Value
| Type | Description |
|---|---|
| ExcelFilterColumnCollection |
Methods
ApplyFilter(bool)
Applies the filter, hiding rows not matching the filter columns
Declaration
public void ApplyFilter(bool calculateRange = false)Parameters
| Type | Name | Description |
|---|---|---|
| bool | calculateRange | If true, any formula in the autofilter range will be calculated before the filter is applied. |
ClearAll()
Clear all columns Unhide all affected cells, nullify address and table.
Declaration
public void ClearAll()