Class XlsAutoFiltersCollection

Namespace

Spire.Xls.Core.Spreadsheet.Collections

Assembly

Spire.XLS.dll

public class XlsAutoFiltersCollection : CollectionExtended<object>, IList<object>, ICollection<object>, IEnumerable<object>, IEnumerable, ICloneParent, IAutoFilters, IExcelApplication

Inheritance

object

CollectionBase<object>

CollectionExtended<object>

XlsAutoFiltersCollection

Implements

IList<object>

ICollection<object>

IEnumerable<object>

IEnumerable

ICloneParent

IAutoFilters

IExcelApplication

Derived

AutoFiltersCollection

Inherited Members

CollectionExtended<object>.OnClear()

CollectionExtended<object>.OnClearComplete()

CollectionExtended<object>.OnInsert(int, object)

CollectionExtended<object>.OnInsertComplete(int, object)

CollectionExtended<object>.OnRemove(int, object)

CollectionExtended<object>.OnRemoveComplete(int, object)

CollectionExtended<object>.OnSet(int, object, object)

CollectionExtended<object>.OnSetComplete(int, object, object)

CollectionExtended<object>.FindParent(Type)

CollectionExtended<object>.FindParent(Type, bool)

CollectionExtended<object>.SetParent(object)

CollectionExtended<object>.Clone(object)

CollectionExtended<object>.EnsureCapacity(int)

CollectionExtended<object>.GenerateDefaultName(ICollection<object>, string)

CollectionExtended<object>.GenerateDefaultName(ICollection, string)

CollectionExtended<object>.GenerateDefaultName(string, params ICollection[])

CollectionExtended<object>.ChangeName(IDictionary, XlsEventArgs)

CollectionExtended<object>.Parent

CollectionExtended<object>.Changed

CollectionBase<object>.Clear()

CollectionBase<object>.Insert(int, object)

CollectionBase<object>.GetEnumerator()

CollectionBase<object>.RemoveAt(int)

CollectionBase<object>.IndexOf(object)

CollectionBase<object>.Add(object)

CollectionBase<object>.Contains(object)

CollectionBase<object>.CopyTo(object[], int)

CollectionBase<object>.Remove(object)

CollectionBase<object>.Capacity

CollectionBase<object>.InnerList

CollectionBase<object>.List

CollectionBase<object>.IsReadOnly

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

AddressR1C1

Gets addres of filtered range in R1C1 style. Read only.

public string AddressR1C1 { get; }

Property Value

string

Count

public int Count { get; }

Property Value

int

HasFiltered

public bool HasFiltered { get; }

Property Value

bool

this[int]

Get auto filter item..

public FilterColumn this[int columnIndex] { get; }

Parameters

columnIndex int

Property Value

FilterColumn

Range

public IXLSRange Range { get; set; }

Property Value

IXLSRange

Sorter

public DataSorter Sorter { get; }

Property Value

DataSorter

Worksheet

public Worksheet Worksheet { get; }

Property Value

Worksheet

Methods

Clone(XlsWorksheet)

public XlsAutoFiltersCollection Clone(XlsWorksheet parent)

Parameters

parent XlsWorksheet

Returns

XlsAutoFiltersCollection