PivotTableCollection Methods
A collection of all PivotTable objects in the worksheet.
Name | Description |
---|---|
Add |
Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created Pivot |
Add |
Creates a pivot table with the default name based on data in the specified cell range and returns the newly created Pivot |
Add |
Creates a new pivot table with a custom name using the specified data cache and returns the newly created Pivot |
Add |
Creates a new pivot table with the default name using the specified data cache and returns the newly created Pivot |
Clear() | Removes all pivot tables from the collection. |
Contains |
Indicates whether the collection contains the specified pivot table. |
Copy |
Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection. |
Get |
Returns an enumerator that iterates through the collection.
Inherited from IEnumerable |
Index |
Returns the index of the specified pivot table in the collection. |
Remove |
Removes the specified pivot table from the collection. |
Remove |
Removes the pivot table at the specified index from the collection. |
See Also