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 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. |
|
Returns a PivotTableSettings object representing the properties of a PivotTable. |
|
|
Returns a |
|
|
Returns a SourceFieldCollection. |
