PivotTableCollection Class

Represents the collection of all the PivotTable objects on the specified worksheet.
Inheritance Hierarchy

Namespace:  Aspose.Cells.Pivot
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 21.7.0.0 (21.7)
Syntax
public class PivotTableCollection : CollectionBase, 
	IDisposable

The PivotTableCollection type exposes the following members.

Properties
Methods
  NameDescription
Public methodAdd(String, String, String)
Adds a new PivotTable cache to a PivotCaches collection.
Public methodAdd(PivotTable, String, String)
Adds a new PivotTable Object to the collection from another PivotTable.
Public methodAdd(String, Int32, Int32, String)
Adds a new PivotTable cache to a PivotCaches collection.
Public methodAdd(String, String, String, Boolean)
Adds a new PivotTable cache to a PivotCaches collection.
Public methodAdd(PivotTable, Int32, Int32, String)
Adds a new PivotTable Object to the collection from another PivotTable.
Public methodAdd(String, Int32, Int32, String, Boolean)
Adds a new PivotTable cache to a PivotCaches collection.
Public methodAdd(String, Boolean, PivotPageFields, String, String)
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
Public methodAdd(String, Boolean, PivotPageFields, Int32, Int32, String)
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
Public methodClear
Clear all pivot tables.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetEnumerator (Inherited from CollectionBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Protected methodOnClear (Inherited from CollectionBase.)
Protected methodOnClearComplete (Inherited from CollectionBase.)
Protected methodOnInsert (Inherited from CollectionBase.)
Protected methodOnInsertComplete (Inherited from CollectionBase.)
Protected methodOnRemove (Inherited from CollectionBase.)
Protected methodOnRemoveComplete (Inherited from CollectionBase.)
Protected methodOnSet (Inherited from CollectionBase.)
Protected methodOnSetComplete (Inherited from CollectionBase.)
Protected methodOnValidate (Inherited from CollectionBase.)
Public methodRemove
Deletes the specified PivotTable
Public methodRemoveAt
Deletes the PivotTable at the specified index
Public methodToString (Inherited from Object.)
See Also