Excel.Interfaces.FilterPivotHierarchyCollectionLoadOptions interface
Represents a collection of FilterPivotHierarchy items associated with the PivotTable.
Remarks
Properties
$all | Specifying |
enable |
For EACH ITEM in the collection: Determines whether to allow multiple filter items. |
id | For EACH ITEM in the collection: ID of the FilterPivotHierarchy. |
name | For EACH ITEM in the collection: Name of the FilterPivotHierarchy. |
position | For EACH ITEM in the collection: Position of the FilterPivotHierarchy. |
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
enableMultipleFilterItems
For EACH ITEM in the collection: Determines whether to allow multiple filter items.
enableMultipleFilterItems?: boolean;
Property Value
boolean
Remarks
id
For EACH ITEM in the collection: ID of the FilterPivotHierarchy.
id?: boolean;
Property Value
boolean
Remarks
name
For EACH ITEM in the collection: Name of the FilterPivotHierarchy.
name?: boolean;
Property Value
boolean
Remarks
position
For EACH ITEM in the collection: Position of the FilterPivotHierarchy.
position?: 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