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.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}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class PivotTable
{signature}
{remarks}
To create a {{PivotTable}} object, call [EW8:
Remarks

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

Int32,

Int32)

]. {remarks} {properties} || Name || Description || | [

.

Properties

Name

Description

ChangeDataSource(Area)

...

Excerpt Include
PivotTable.ChangeDataSource(Area)

...

PivotTable.ChangeDataSource(Area)

...

nopanel

...

true

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