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 aPivotTable
object, call PivotTables.CreatePivotTable(Area, Int32, Int32).
Properties
Name |
Description |
|
---|---|---|
[ChangeDataSource(Area) |
PivotTable.ChangeDataSource(Area) |
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. |