Excel.Interfaces.PivotTableData interface
An interface describing the data returned by calling pivotTable.toJSON().
Properties
| column |
The Column Pivot Hierarchies of the PivotTable. |
| data |
The Data Pivot Hierarchies of the PivotTable. |
| filter |
The Filter Pivot Hierarchies of the PivotTable. |
| hierarchies | The Pivot Hierarchies of the PivotTable. |
| id | ID of the PivotTable. |
| name | Name of the PivotTable. |
| row |
The Row Pivot Hierarchies of the PivotTable. |
Property Details
columnHierarchies
The Column Pivot Hierarchies of the PivotTable.
columnHierarchies?: Excel.Interfaces.RowColumnPivotHierarchyData[];Property Value
Remarks
dataHierarchies
The Data Pivot Hierarchies of the PivotTable.
dataHierarchies?: Excel.Interfaces.DataPivotHierarchyData[];Property Value
Remarks
filterHierarchies
The Filter Pivot Hierarchies of the PivotTable.
filterHierarchies?: Excel.Interfaces.FilterPivotHierarchyData[];Property Value
Remarks
hierarchies
The Pivot Hierarchies of the PivotTable.
hierarchies?: Excel.Interfaces.PivotHierarchyData[];Property Value
Remarks
id
name
rowHierarchies
The Row Pivot Hierarchies of the PivotTable.
rowHierarchies?: Excel.Interfaces.RowColumnPivotHierarchyData[];