ConditionalFormattingIcon

ConditionalFormattingIcon class

Represents the custom icon of conditional formatting rule.

class ConditionalFormattingIcon;

Methods

MethodDescription
getType()Gets and sets the icon set type.
setType(IconSetType)Gets and sets the icon set type.
getIndex()Gets and sets the icon’s index in the icon set.
setIndex(number)Gets and sets the icon’s index in the icon set.
getImageData(Cell)Gets the image data with the setting of cell.
static getIconImageData(IconSetType, number)Get the icon set data

getType()

Gets and sets the icon set type.

getType() : IconSetType;

Returns

IconSetType

setType(IconSetType)

Gets and sets the icon set type.

setType(value: IconSetType) : void;

Parameters:

ParameterTypeDescription
valueIconSetTypeThe value to set.

getIndex()

Gets and sets the icon’s index in the icon set.

getIndex() : number;

setIndex(number)

Gets and sets the icon’s index in the icon set.

setIndex(value: number) : void;

Parameters:

ParameterTypeDescription
valuenumberThe value to set.

getImageData(Cell)

Gets the image data with the setting of cell.

getImageData(cell: Cell) : number[];

Parameters:

ParameterTypeDescription
cellCellThe setting of cell.

Returns

Returns the image data of icon.

getIconImageData(IconSetType, number)

Get the icon set data

static getIconImageData(type: IconSetType, index: number) : number[];

Parameters:

ParameterTypeDescription
typeIconSetTypeicon’s type
indexnumbericon’s index

Returns

number[]