Edit

Share via

Excel.Interfaces.SlicerItemData interface

  • Reference
Package:
excel

An interface describing the data returned by calling slicerItem.toJSON().

Properties

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

hasData

Value is true if the slicer item has data.

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.

isSelected?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.10 ]

key

Represents the unique value representing the slicer item.

key?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.10 ]

name

Represents the title displayed in the Excel UI.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.10 ]