Introduced in build 8.3
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 |
|
Returns an IEnumerator for the PivotTables in a Worksheet. |
|
Permanently removes the specified PivotTable from the worksheet. | |
Permanently removes the PivotTable at the specified position from the worksheet. |