Introduced in build 8.4
Description
The PivotTables collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use PivotTables.
C#
vb.net
Properties
Name |
Description |
|---|---|
| Returns the number of PivotTables in the worksheet. |
Indexers
Name |
Description |
|---|---|
Returns the PivotTable at the specified 0-based position in the PivotTables collection. |
|
Returns the PivotTable with the specified name in the PivotTables collection. |
Methods
Name |
Description |
|---|---|
|
Creates a new, blank PivotTable for the specified area. A PivotTable created by this method is part of |
|
|
Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of |
|
|
Returns an IEnumerator for the PivotTables in a Worksheet. |
