PivotTableCollection Methods
A collection of all PivotTable objects in the worksheet.| Name | Description |
|---|---|
| Add(PivotCache, Range, String) | Creates a new pivot table with a custom name using the specified data cache and returns the newly created PivotTable object. |
| Add(PivotCache, Range) | Creates a new pivot table with the default name using the specified data cache and returns the newly created PivotTable object. |
| Add(Range, Range, 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(Range, Range) | Creates a pivot table with the default name based on data in the specified cell range 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. |
See Also