Show / Hide Table of Contents

Class ExcelValueFilterCollection

A collection of value filters

Inheritance
System.Object
ExcelFilterCollectionBase<ExcelFilterItem>
ExcelValueFilterCollection
Implements
System.Collections.Generic.IEnumerable<ExcelFilterItem>
System.Collections.IEnumerable
Inherited Members
ExcelFilterCollectionBase<ExcelFilterItem>._list
ExcelFilterCollectionBase<ExcelFilterItem>._maxTwoItems
ExcelFilterCollectionBase<ExcelFilterItem>.GetEnumerator()
ExcelFilterCollectionBase<ExcelFilterItem>.IEnumerable.GetEnumerator()
ExcelFilterCollectionBase<ExcelFilterItem>.Item[Int32]
ExcelFilterCollectionBase<ExcelFilterItem>.Count
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

Clear()

Clears the collection

Declaration
public void Clear()

Remove(ExcelFilterItem)

Remove the item from the list

Declaration
public void Remove(ExcelFilterItem item)
Parameters
Type Name Description
ExcelFilterItem item

The item to remove

RemoveAt(Int32)

Remove the item at the specified index from the list

Declaration
public void RemoveAt(int index)
Parameters
Type Name Description
System.Int32 index

The index in the list

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
Back to top Generated by DocFX