Class ExcelAutoFilter

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

public class ExcelAutoFilter : XmlHelper

Inherited Members: object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

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

public ExcelAddressBase Address { get; }

The columns to filter

public ExcelFilterColumnCollection Columns { get; }

Applies the filter, hiding rows not matching the filter columns

public void ApplyFilter(bool calculateRange = false)

calculateRange bool: If true, any formula in the autofilter range will be calculated before the filter is applied.

Clear all columns Unhide all affected cells, nullify address and table.

public void ClearAll()