Class XlsPivotTablesCollection

Namespace

Spire.Xls.Core.Spreadsheet.Collections

Assembly

Spire.XLS.dll

public class XlsPivotTablesCollection : CollectionExtended<IPivotTable>, IList<IPivotTable>, ICollection<IPivotTable>, IEnumerable<IPivotTable>, IEnumerable, IExcelApplication, ICloneParent, IPivotTables

Inheritance

object

CollectionBase<IPivotTable>

CollectionExtended<IPivotTable>

XlsPivotTablesCollection

Implements

IList<IPivotTable>

ICollection<IPivotTable>

IEnumerable<IPivotTable>

IEnumerable

IExcelApplication

ICloneParent

IPivotTables

Derived

PivotTablesCollection

Inherited Members

CollectionExtended<IPivotTable>.OnClear()

CollectionExtended<IPivotTable>.OnClearComplete()

CollectionExtended<IPivotTable>.OnInsert(int, IPivotTable)

CollectionExtended<IPivotTable>.OnInsertComplete(int, IPivotTable)

CollectionExtended<IPivotTable>.OnRemove(int, IPivotTable)

CollectionExtended<IPivotTable>.OnRemoveComplete(int, IPivotTable)

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

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

CollectionExtended<IPivotTable>.FindParent(Type)

CollectionExtended<IPivotTable>.FindParent(Type, bool)

CollectionExtended<IPivotTable>.SetParent(object)

CollectionExtended<IPivotTable>.Clone(object)

CollectionExtended<IPivotTable>.EnsureCapacity(int)

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

CollectionExtended<IPivotTable>.GenerateDefaultName(ICollection, string)

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

CollectionExtended<IPivotTable>.ChangeName(IDictionary, XlsEventArgs)

CollectionExtended<IPivotTable>.Parent

CollectionExtended<IPivotTable>.Changed

CollectionBase<IPivotTable>.Insert(int, IPivotTable)

CollectionBase<IPivotTable>.GetEnumerator()

CollectionBase<IPivotTable>.IndexOf(IPivotTable)

CollectionBase<IPivotTable>.Add(IPivotTable)

CollectionBase<IPivotTable>.Contains(IPivotTable)

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

CollectionBase<IPivotTable>.Capacity

CollectionBase<IPivotTable>.InnerList

CollectionBase<IPivotTable>.List

CollectionBase<IPivotTable>.IsReadOnly

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Count

public int Count { get; }

Property Value

int

this[int]

public IPivotTable this[int index] { get; }

Parameters

index int

Property Value

IPivotTable

this[string]

public IPivotTable this[string name] { get; }

Parameters

name string

Property Value

IPivotTable

ParentWorksheet

public XlsWorksheetBase ParentWorksheet { get; }

Property Value

XlsWorksheetBase

Methods

Add(string, CellRange, PivotCache)

public PivotTable Add(string name, CellRange location, PivotCache cache)

Parameters

name string

location CellRange

cache PivotCache

Returns

PivotTable

Clear()

public void Clear()

Clone(XlsWorksheet, Dictionary<string, string>)

public PivotTablesCollection Clone(XlsWorksheet worksheet, Dictionary<string, string> hashWorksheetNames)

Parameters

worksheet XlsWorksheet

hashWorksheetNames Dictionary<string, string>

Returns

PivotTablesCollection

Remove(IPivotTable)

public void Remove(IPivotTable pivotTable)

Parameters

pivotTable IPivotTable

Remove(string)

public void Remove(string name)

Parameters

name string

RemoveAt(int)

public void RemoveAt(int index)

Parameters

index int