Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

The PivotTables collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use Worksheet.PivotTables.
C#
vb.net

Properties

Name

Description

Count

Returns the number of PivotTables in the worksheet.

Indexers

Name

Description

Item(Int32)

Returns the PivotTable at the specified 0-based position in the PivotTables collection.

Item(String)

Returns the PivotTable with the specified name in the PivotTables collection.

Methods

Name

Description

CreatePivotTable(Area, Int32, Int32)

Creates a new, blank PivotTable for the specified area. A PivotTable created by this method is part of PivotTables collection.

CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)

Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of PivotTables collection.

GetEnumerator()

Returns an IEnumerator for the PivotTables in a Worksheet .
  • No labels