Class MultipleFilterCollection

Namespace

Spire.Xls.Core.Spreadsheet.AutoFilter

Assembly

Spire.XLS.dll

public class MultipleFilterCollection : CollectionBase, IList, ICollection, IEnumerable

Inheritance

object

CollectionBase

MultipleFilterCollection

Implements

IList

ICollection

IEnumerable

Inherited Members

CollectionBase.OnSet(int, object, object)

CollectionBase.OnInsert(int, object)

CollectionBase.OnClear()

CollectionBase.OnRemove(int, object)

CollectionBase.OnValidate(object)

CollectionBase.OnSetComplete(int, object, object)

CollectionBase.OnInsertComplete(int, object)

CollectionBase.OnClearComplete()

CollectionBase.OnRemoveComplete(int, object)

CollectionBase.InnerList

CollectionBase.List

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

MultipleFilterCollection(FilterColumn)

public MultipleFilterCollection(FilterColumn parentcol)

Parameters

parentcol FilterColumn

Properties

Capacity

public int Capacity { get; set; }

Property Value

int

Count

public int Count { get; }

Property Value

int

this[int]

public object this[int index] { get; }

Parameters

index int

Property Value

object

MatchBlank

public bool MatchBlank { get; set; }

Property Value

bool

Methods

Add(DateTimeGroupItem)

public void Add(DateTimeGroupItem filter)

Parameters

filter DateTimeGroupItem

Add(DateTimeGroupingType, int, int, int)

public void Add(DateTimeGroupingType type, int year, int month, int day)

Parameters

type DateTimeGroupingType

year int

month int

day int

Add(string)

public void Add(string filter)

Parameters

filter string

Clear()

public void Clear()

GetByIndex(int)

public object GetByIndex(int index)

Parameters

index int

Returns

object

GetEnumerator()

public IEnumerator GetEnumerator()

Returns

IEnumerator

RemoveAt(int)

public void RemoveAt(int index)

Parameters

index int

RemoveDateFilter(DateTimeGroupingType, int, int, int, int, int, int)

Remove a date in the filter.

public void RemoveDateFilter(DateTimeGroupingType type, int year, int month, int day, int hour, int minute, int second)

Parameters

type DateTimeGroupingType

year int

month int

day int

hour int

minute int

second int

RemoveFilter(string)

public void RemoveFilter(string filter)

Parameters

filter string