Skip to end of metadata
Go to start of metadata

Introduced in build 8.6.1

Description

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

C#
vb.net

Parameters

data
The data that is represented within the PivotTable.
aRow
The 0-based number of the row of the upper left corner of the PivotTable.
aColumn
The 0-based number of the column of the upper left corner of the PivotTable.

Remarks

This constructor will create Row, Column, and Value as ?SourceFields.  These ?SourceFields will be created using the same algorithm that the Pivot Table Wizard in Excel uses to create Multiple Consolidation Pivot Tables.

Examples

C#
vb.net
  • No labels