Excel.Interfaces.SlicerItemCollectionLoadOptions interface
Represents a collection of all the slicer item objects in the slicer.
Remarks
Properties
$all | Specifying |
has |
For EACH ITEM in the collection: Value is |
is |
For EACH ITEM in the collection: Value is |
key | For EACH ITEM in the collection: Represents the unique value representing the slicer item. |
name | For EACH ITEM in the collection: Represents the title displayed in the Excel UI. |
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
hasData
For EACH ITEM in the collection: Value is true
if the slicer item has data.
hasData?: boolean;
Property Value
boolean
Remarks
isSelected
For EACH ITEM in the collection: Value is true
if the slicer item is selected. Setting this value will not clear the selected state of other slicer items. By default, if the slicer item is the only one selected, when it is deselected, all items will be selected.
isSelected?: boolean;
Property Value
boolean
Remarks
key
For EACH ITEM in the collection: Represents the unique value representing the slicer item.
key?: boolean;
Property Value
boolean
Remarks
name
For EACH ITEM in the collection: Represents the title displayed in the Excel UI.
name?: 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