Page tree

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.34
8.34
Description

Excerpt

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

Signature
C#
C#
 public sealed class PivotTable

...

Remarks

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

Properties

Name

Description

PivotTableSettings ChangeDataSource(Area)

Excerpt Include
EW8:PivotTable.PivotTableSettingsEW8:ChangeDataSource(Area)
PivotTable.PivotTableSettingsChangeDataSource(Area)
nopaneltrue

ColumnLabels

Excerpt Include
EW8:PivotTable.ColumnLabelsEW8:
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
EW8:PivotTable.RowLabelsEW8:
PivotTable.RowLabels
nopaneltrue

DataFields SourceFields

Excerpt Include
EW8:PivotTable.DataFieldsSourceFieldsEW8:
PivotTable.DataFieldsSourceFields
nopaneltrue
Scrollbar