Excel.Interfaces.DataPivotHierarchyLoadOptions interface
Represents the Excel DataPivotHierarchy.
Remarks
Properties
$all | Specifying |
field | Returns the PivotFields associated with the DataPivotHierarchy. |
id | ID of the DataPivotHierarchy. |
name | Name of the DataPivotHierarchy. |
number |
Number format of the DataPivotHierarchy. |
position | Position of the DataPivotHierarchy. |
show |
Specifies if the data should be shown as a specific summary calculation. |
summarize |
Specifies if all items of the DataPivotHierarchy are shown. |
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
field
Returns the PivotFields associated with the DataPivotHierarchy.
field?: Excel.Interfaces.PivotFieldLoadOptions;
Property Value
Remarks
id
ID of the DataPivotHierarchy.
id?: boolean;
Property Value
boolean
Remarks
name
Name of the DataPivotHierarchy.
name?: boolean;
Property Value
boolean
Remarks
numberFormat
Number format of the DataPivotHierarchy.
numberFormat?: boolean;
Property Value
boolean
Remarks
position
Position of the DataPivotHierarchy.
position?: boolean;
Property Value
boolean
Remarks
showAs
Specifies if the data should be shown as a specific summary calculation.
showAs?: boolean;
Property Value
boolean
Remarks
summarizeBy
Specifies if all items of the DataPivotHierarchy are shown.
summarizeBy?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for