Excel.Interfaces.PivotHierarchyLoadOptions interface

  • Reference
Package:
excel

Represents the Excel PivotHierarchy.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
id

ID of the PivotHierarchy.
name

Name of the PivotHierarchy.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

id

ID of the PivotHierarchy.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotHierarchy.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]