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<ExcelFilterItem>

IEnumerable

Inherited Members

ExcelFilterCollectionBase<ExcelFilterItem>.GetEnumerator()

ExcelFilterCollectionBase<ExcelFilterItem>.this[int]

ExcelFilterCollectionBase<ExcelFilterItem>.Count

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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