Edit

Share via

Excel.Interfaces.PivotTableData interface

  • Reference
Package:
excel

An interface describing the data returned by calling pivotTable.toJSON().

Properties

columnHierarchies

The Column Pivot Hierarchies of the PivotTable.
dataHierarchies

The Data Pivot Hierarchies of the PivotTable.
filterHierarchies

The Filter Pivot Hierarchies of the PivotTable.
hierarchies

The Pivot Hierarchies of the PivotTable.
id

ID of the PivotTable.
name

Name of the PivotTable.
rowHierarchies

The Row Pivot Hierarchies of the PivotTable.

Property Details

columnHierarchies

The Column Pivot Hierarchies of the PivotTable.

columnHierarchies?: Excel.Interfaces.RowColumnPivotHierarchyData[];

Property Value

Excel.Interfaces.RowColumnPivotHierarchyData[]

Remarks

[ API set: ExcelApi 1.8 ]

dataHierarchies

The Data Pivot Hierarchies of the PivotTable.

dataHierarchies?: Excel.Interfaces.DataPivotHierarchyData[];

Property Value

Excel.Interfaces.DataPivotHierarchyData[]

Remarks

[ API set: ExcelApi 1.8 ]

filterHierarchies

The Filter Pivot Hierarchies of the PivotTable.

filterHierarchies?: Excel.Interfaces.FilterPivotHierarchyData[];

Property Value

Excel.Interfaces.FilterPivotHierarchyData[]

Remarks

[ API set: ExcelApi 1.8 ]

hierarchies

The Pivot Hierarchies of the PivotTable.

hierarchies?: Excel.Interfaces.PivotHierarchyData[];

Property Value

Excel.Interfaces.PivotHierarchyData[]

Remarks

[ API set: ExcelApi 1.8 ]

id

ID of the PivotTable.

id?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.5 ]

name

Name of the PivotTable.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.3 ]

rowHierarchies

The Row Pivot Hierarchies of the PivotTable.

rowHierarchies?: Excel.Interfaces.RowColumnPivotHierarchyData[];

Property Value

Excel.Interfaces.RowColumnPivotHierarchyData[]

Remarks

[ API set: ExcelApi 1.8 ]