OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools
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 13 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(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. 

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