Introduced in build 8.4
Description
ThePivotTables collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use Worksheet.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 . |
