Excel.Interfaces.PivotHierarchyData interface

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

Properties

fields

Returns the PivotFields associated with the PivotHierarchy.

id

ID of the PivotHierarchy.

name

Name of the PivotHierarchy.

Property Details

fields

Returns the PivotFields associated with the PivotHierarchy.

fields?: Excel.Interfaces.PivotFieldData[];

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

id

ID of the PivotHierarchy.

id?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotHierarchy.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]