Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotTableCollection Methods
Show Inherited Hide Inherited

A collection of all PivotTable objects in the worksheet.
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.
See Also