Excel.Interfaces.PivotHierarchyLoadOptions interface

Represents the Excel PivotHierarchy.

[ API set: ExcelApi 1.8 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

id

Id of the PivotHierarchy.

[ API set: ExcelApi 1.8 ]

name

Name of the PivotHierarchy.

[ API set: ExcelApi 1.8 ]

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

id

Id of the PivotHierarchy.

[ API set: ExcelApi 1.8 ]

id?: boolean;

Property Value

boolean

name

Name of the PivotHierarchy.

[ API set: ExcelApi 1.8 ]

name?: boolean;

Property Value

boolean