OfficeWriter Documentation
.
ExcelWriter v10 Docs
Space Shortcuts
Page tree
ConfigureSpace tools
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. 
PivotTableLayoutReturns a PivotTableLayout object representing the layout of a PivotTable.

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