Edit

Share via

ExcelScript.SlicerItem interface

  • Reference
Package:
ExcelScript

Represents a slicer item in a slicer.

Methods

getHasData()

Value is true if the slicer item has data.
getIsSelected()

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

Represents the unique value representing the slicer item.
getName()

Represents the title displayed in the Excel UI.
setIsSelected(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.

Method Details

getHasData()

Value is true if the slicer item has data.

getHasData(): boolean;

Returns

boolean

getIsSelected()

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.

getIsSelected(): boolean;

Returns

boolean

getKey()

Represents the unique value representing the slicer item.

getKey(): string;

Returns

string

getName()

Represents the title displayed in the Excel UI.

getName(): string;

Returns

string

setIsSelected(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.

setIsSelected(isSelected: boolean): void;

Parameters

isSelected

boolean

Returns

void