officefileapi-devexpress-dot-spreadsheet-dot-pivottablecollection-dot-underscore-members.md
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. |
See Also