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. |
| enable |
Specifies if the PivotTable allows values in the data body to be edited by the user. |
| 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. |
| use |
Specifies if the PivotTable uses custom lists when sorting. |
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
enableDataValueEditing
Specifies if the PivotTable allows values in the data body to be edited by the user.
enableDataValueEditing?: boolean;Property Value
boolean
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[];Property Value
Remarks
useCustomSortLists
Specifies if the PivotTable uses custom lists when sorting.
useCustomSortLists?: boolean;Property Value
boolean