Excel.Interfaces.FilterPivotHierarchyData interface
An interface describing the data returned by calling filterPivotHierarchy.toJSON()
.
Properties
enable |
Determines whether to allow multiple filter items. |
fields | Returns the PivotFields associated with the FilterPivotHierarchy. |
id | ID of the FilterPivotHierarchy. |
name | Name of the FilterPivotHierarchy. |
position | Position of the FilterPivotHierarchy. |
Property Details
enableMultipleFilterItems
Determines whether to allow multiple filter items.
enableMultipleFilterItems?: boolean;
Property Value
boolean
Remarks
fields
Returns the PivotFields associated with the FilterPivotHierarchy.
fields?: Excel.Interfaces.PivotFieldData[];
Property Value
Remarks
id
ID of the FilterPivotHierarchy.
id?: string;
Property Value
string
Remarks
name
Name of the FilterPivotHierarchy.
name?: string;
Property Value
string
Remarks
position
Position of the FilterPivotHierarchy.
position?: number;
Property Value
number
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