Excel.Interfaces.PivotHierarchyLoadOptions interface
Represents the Excel PivotHierarchy.
Remarks
Properties
$all | Specifying |
id | ID of the PivotHierarchy. |
name | Name of the PivotHierarchy. |
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
name
Name of the PivotHierarchy.
name?: boolean;
Property Value
boolean
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins