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 7 Next »

Introduced in build 8.3

Description

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

C#
vb.net

Remarks

To create a PivotTable object, call PivotTables.CreatePivotTable.

Properties

Name

Description

PivotTableSettings

Returns a PivotTableSettings object representing the properties of a PivotTable.

ColumnLabels

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

RowLabels

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

  • No labels