PivotTableCollection Members

A collection of all PivotTable objects in the worksheet.

Name	Description
Count	Gets the number of elements contained in the ICollection. Inherited from ICollection.
First	Returns the first pivot table in the PivotTableCollection.
IsSynchronized	Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
Item[String]	Provides access to an individual pivot table in the collection by its name.
Last	Returns the last pivot table in the PivotTableCollection.
SyncRoot	Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Name	Description
Add(CellRange, CellRange, String)	Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created PivotTable object.
Add(CellRange, CellRange)	Creates a pivot table with the default name based on data in the specified cell range and returns the newly created PivotTable object.
Add(PivotCache, CellRange, String)	Creates a new pivot table with a custom name using the specified data cache and returns the newly created PivotTable object.
Add(PivotCache, CellRange)	Creates a new pivot table with the default name using the specified data cache and returns the newly created PivotTable object.
Clear()	Removes all pivot tables from the collection.
Contains(PivotTable)	Indicates whether the collection contains the specified pivot table.
CopyTo(Array, Int32)	Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator()	Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(PivotTable)	Returns the index of the specified pivot table in the collection.
Remove(PivotTable)	Removes the specified pivot table from the collection.
RemoveAt(Int32)	Removes the pivot table at the specified index from the collection.

Properties