Class ExcelAutoFilter

Represents an Autofilter for a worksheet or a filter of a table

Inheritance

System.Object

XmlHelper

ExcelAutoFilter

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelAutoFilter : XmlHelper

Properties

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(Boolean)

Applies the filter, hiding rows not matching the filter columns

Declaration

public void ApplyFilter(bool calculateRange = false)

Parameters

Type	Name	Description
System.Boolean	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()