Excel.Interfaces.DataPivotHierarchyCollectionLoadOptions interface
Represents a collection of DataPivotHierarchy items associated with the PivotTable.
Remarks
Properties
$all | Specifying |
field | For EACH ITEM in the collection: Returns the PivotFields associated with the DataPivotHierarchy. |
id | For EACH ITEM in the collection: ID of the DataPivotHierarchy. |
name | For EACH ITEM in the collection: Name of the DataPivotHierarchy. |
number |
For EACH ITEM in the collection: Number format of the DataPivotHierarchy. |
position | For EACH ITEM in the collection: Position of the DataPivotHierarchy. |
show |
For EACH ITEM in the collection: Specifies if the data should be shown as a specific summary calculation. |
summarize |
For EACH ITEM in the collection: Specifies if all items of the DataPivotHierarchy are shown. |
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
field
For EACH ITEM in the collection: Returns the PivotFields associated with the DataPivotHierarchy.
field?: Excel.Interfaces.PivotFieldLoadOptions;
Property Value
Remarks
id
For EACH ITEM in the collection: ID of the DataPivotHierarchy.
id?: boolean;
Property Value
boolean
Remarks
name
For EACH ITEM in the collection: Name of the DataPivotHierarchy.
name?: boolean;
Property Value
boolean
Remarks
numberFormat
For EACH ITEM in the collection: Number format of the DataPivotHierarchy.
numberFormat?: boolean;
Property Value
boolean
Remarks
position
For EACH ITEM in the collection: Position of the DataPivotHierarchy.
position?: boolean;
Property Value
boolean
Remarks
showAs
For EACH ITEM in the collection: Specifies if the data should be shown as a specific summary calculation.
showAs?: boolean;
Property Value
boolean
Remarks
summarizeBy
For EACH ITEM in the collection: Specifies if all items of the DataPivotHierarchy are shown.
summarizeBy?: boolean;
Property Value
boolean
Remarks
Office Add-ins