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. |