Class ExcelValueFilterCollection

A collection of value filters

Inheritance
System.Object
ExcelFilterCollectionBase<ExcelFilterItem>
ExcelValueFilterCollection
Implements
System.Collections.Generic.IEnumerable<ExcelFilterItem>
System.Collections.IEnumerable
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 ExcelValueFilterCollection : ExcelFilterCollectionBase<ExcelFilterItem>, IEnumerable<ExcelFilterItem>, IEnumerable

Properties

Blank

Flag indicating whether to filter by blank

Declaration
public bool Blank { get; set; }
Property Value
Type Description
System.Boolean

Methods

Add(ExcelFilterDateGroupItem)

Add a Date filter item.

Declaration
public ExcelFilterDateGroupItem Add(ExcelFilterDateGroupItem value)
Parameters
Type Name Description
ExcelFilterDateGroupItem value
Returns
Type Description
ExcelFilterDateGroupItem

Add(ExcelFilterValueItem)

Add a filter value that will be matched agains the ExcelRange.Text property

Declaration
public ExcelFilterValueItem Add(ExcelFilterValueItem item)
Parameters
Type Name Description
ExcelFilterValueItem item

The value
Returns
Type Description
ExcelFilterValueItem

The filter value item

Add(String)

Add a filter value that will be matched agains the ExcelRange.Text property

Declaration
public ExcelFilterValueItem Add(string value)
Parameters
Type Name Description
System.String value

The value
Returns
Type Description
ExcelFilterValueItem

The filter value item

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable