Excel.Interfaces.SlicerItemCollectionLoadOptions interface

Package:

excel

Represents a collection of all the slicer item objects in the slicer.

Remarks

[ API set: ExcelApi 1.10 ]

Properties

$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).
hasData	For EACH ITEM in the collection: Value is true if the slicer item has data.
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.
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

[ API set: ExcelApi 1.10 ]

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

[ API set: ExcelApi 1.10 ]

key

For EACH ITEM in the collection: Represents the unique value representing the slicer item.

key?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

name

For EACH ITEM in the collection: Represents the title displayed in the Excel UI.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]