Excel.Interfaces.PivotHierarchyLoadOptions interface
Represents the Excel PivotHierarchy.
Remarks
[Api set: ExcelApi 1.8]
Properties
| $all | Specifying |
| 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]