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

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.