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

Applies the filter, hiding rows not matching the filter columns

Declaration
public void ApplyFilter()