Class ExcelAutoFilter¶

Namespace: OfficeOpenXml.Filter
Assembly: EPPlus.dll

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

public class ExcelAutoFilter : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelAutoFilter

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Address¶

The range of the autofilter Autofilter with address "" or null indicates empty autofilter.

public ExcelAddressBase Address { get; }

Property Value¶

ExcelAddressBase

Columns¶

The columns to filter

public ExcelFilterColumnCollection Columns { get; }

Property Value¶

ExcelFilterColumnCollection

Methods¶

ApplyFilter(bool)¶

Applies the filter, hiding rows not matching the filter columns

public void ApplyFilter(bool calculateRange = false)

Parameters¶

calculateRange bool

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.

public void ClearAll()