Excel.Interfaces.SlicerItemLoadOptions interface

Package:

excel

Represents a slicer item in a slicer.

Remarks

[ API set: ExcelApi 1.10 ]

Properties

$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).
hasData	Value is true if the slicer item has data.
isSelected	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	Represents the unique value representing the slicer item.
name	Represents the title displayed in the Excel UI.

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).

TypeScript

$all?: boolean;

Property Value

boolean

hasData

Value is true if the slicer item has data.

TypeScript

hasData?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

isSelected

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.

TypeScript

isSelected?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

key

Represents the unique value representing the slicer item.

TypeScript

key?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

name

Represents the title displayed in the Excel UI.

TypeScript

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]