Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.Interfaces.PivotHierarchyLoadOptions interface

Package:
excel

Represents the Excel PivotHierarchy.

Remarks

API set: ExcelApi 1.8

Used by

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

Feedback

Was this page helpful?