A PivotTable object represents a PivotTable in a worksheet and allows the PivotTable to be managed.

 public sealed class PivotTable
Public NotInheritable Class PivotTable

To create a PivotTable object, call PivotTables.CreatePivotTable(Area, Int32, Int32).

Name

Description

ChangeDataSource(Area)

ColumnLabels

DataFields

Name

PageFields

PivotTableLayout

PivotTableSettings

RowLabels

SourceFields