Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

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

C#
vb.net

Remarks

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

Properties

Name

Description

ChangeDataSource(Area)

Changes the data source of the PivotTable to a new Area.

ColumnLabels

Returns a FieldCollection object representing a list of column labels in a PivotTable. The items in the collection are PivotTableFields of type ColumnLabel.

DataFields

Returns a FieldCollection object representing a list of data fields (a.k.a value fields) in a PivotTable. The items in the collection are PivotTableFields of type DataField

Name

Sets or returns the name of the PivotTable.

PageFields

Returns a FieldCollection object representing a list of page fields in a PivotTable. The items in the collection are PivotTableFields of type PageField

PivotTableSettings

Returns a PivotTableSettings object representing the properties of a PivotTable.

RowLabels

Returns a FieldCollection object representing a list of row labels in a PivotTable. The items in the collection are PivotTableFields of type RowLabel.

SourceFields

Returns a SourceFieldCollection.

  • No labels