Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

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

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