Introduced in build 8.4
Description
APivotTable object represents a PivotTable in a worksheet and allows the PivotTable to be managed.
C#
vb.net
Remarks
To create aPivotTable object, call PivotTables.CreatePivotTable(Area, Int32, Int32).
Properties
Name | Description |
|---|---|
|
Changes the data source of the | |
Returns a FieldCollection object representing a list of column labels in a PivotTable. The items in the collection are PivotTableFields of type ColumnLabel. | |
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. | |
| Sets or returns the name of the PivotTable. | |
Returns a FieldCollection object representing a list of page fields in a PivotTable. The items in the collection are PivotTableFields of type PageField. | |
| PivotTableLayout | Returns a PivotTableLayout object representing the layout of a PivotTable. |
Returns a PivotTableSettings object representing the properties of a PivotTable. | |
|
Returns a | |
|
Returns a SourceFieldCollection. |
