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

 public sealed class PivotTable
Public NotInheritable Class PivotTable

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

Name

Description

ColumnLabels

DataFields

PageFields

Name

PivotTableSettings

RowLabels

SourceFields