Class ExcelValueFilterCollection¶

Namespace: OfficeOpenXml.Filter
Assembly: EPPlus.dll

A collection of value filters

public class ExcelValueFilterCollection : ExcelFilterCollectionBase<ExcelFilterItem>, IEnumerable<ExcelFilterItem>, IEnumerable

Inheritance¶

object ← ExcelFilterCollectionBase<ExcelFilterItem> ← ExcelValueFilterCollection

Implements¶

IEnumerable
IEnumerable<ExcelFilterItem>

Inherited Members¶

ExcelFilterCollectionBase<ExcelFilterItem>.Count
ExcelFilterCollectionBase<ExcelFilterItem>.GetEnumerator()
ExcelFilterCollectionBase<ExcelFilterItem>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelValueFilterCollection()¶

public ExcelValueFilterCollection()

Properties¶

Blank¶

Flag indicating whether to filter by blank

public bool Blank { get; set; }

Property Value¶

bool

Methods¶

Add(ExcelFilterDateGroupItem)¶

Add a Date filter item.

public ExcelFilterDateGroupItem Add(ExcelFilterDateGroupItem value)

Parameters¶

value ExcelFilterDateGroupItem

Returns¶

ExcelFilterDateGroupItem

Add(ExcelFilterValueItem)¶

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

If value is "" or null sets Blank=True instead of adding.

public ExcelFilterValueItem Add(ExcelFilterValueItem item)

Parameters¶

item ExcelFilterValueItem

The value to add. If "" or null sets Blank=True instead.

Returns¶

ExcelFilterValueItem

The filter value item

Add(string)¶

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

If value is "" or null sets Blank=True instead of adding.

public ExcelFilterValueItem Add(string value)

Parameters¶

value string

The value to add. If "" or null sets Blank=True instead.

Returns¶

ExcelFilterValueItem

The filter value item

Clear()¶

Clears the collection

public void Clear()

Remove(ExcelFilterItem)¶

Remove the item from the list

public void Remove(ExcelFilterItem item)

Parameters¶

item ExcelFilterItem

The item to remove

RemoveAt(int)¶

Remove the item at the specified index from the list

public void RemoveAt(int index)

Parameters¶

index int

The index in the list