Class ExcelValueFilterCollection

A collection of value filters

Inheritance
object
ExcelFilterCollectionBase<ExcelFilterItem>
ExcelValueFilterCollection
Implements
Inherited Members
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
bool

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.String property

If value is "" or null sets Blank=True instead of adding.
Declaration
public ExcelFilterValueItem Add(ExcelFilterValueItem item)
Parameters
Type Name Description
ExcelFilterValueItem item

The value to add. If "" or null sets Blank=True instead.
Returns
Type Description
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.
Declaration
public ExcelFilterValueItem Add(string value)
Parameters
Type Name Description
string value

The value to add. If "" or null sets Blank=True instead.
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(int)

Remove the item at the specified index from the list

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

The index in the list

Implements