Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
8.4
8.4
Description

Excerpt

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

Signature
C#
C#
 public sealed class PivotTable
Signature
vb.net
vb.net
Public NotInheritable Class PivotTable
Remarks

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

Properties

Name

Description

ChangeDataSource(Area)

Excerpt Include
PivotTable.ChangeDataSource(Area)
PivotTable.ChangeDataSource(Area)
nopaneltrue

ColumnLabels

Excerpt Include
PivotTable.ColumnLabels
PivotTable.ColumnLabels
nopaneltrue

DataFields

Excerpt Include
PivotTable.DataFields
PivotTable.DataFields
nopaneltrue

Name

Excerpt Include
PivotTable.Name
PivotTable.Name
nopaneltrue

PageFields

Excerpt Include
PivotTable.PageFields
PivotTable.PageFields
nopaneltrue

PivotTableSettings

Excerpt Include
PivotTable.PivotTableSettings
PivotTable.PivotTableSettings
nopaneltrue

RowLabels

Excerpt Include
PivotTable.RowLabels
PivotTable.RowLabels
nopaneltrue

SourceFields

Excerpt Include
PivotTable.SourceFields
PivotTable.SourceFields
nopaneltrue
Scrollbar