ConditionalFormattingIcon

ConditionalFormattingIcon class

Represents the custom icon of conditional formatting rule.

Properties

NameTypeDescription
ImageDatabyte[]Gets the icon set data.
TypeNumberGets and sets the icon set type. The value of the property is IconSetType integer constant.
IndexNumberGets and sets the icon’s index in the icon set.

Methods

NameDescription
getIconImageDataGet the icon set data
getImageDataGets the image data with the setting of cell.

ConditionalFormattingIcon.ImageData property

Gets the icon set data.

Type: byte[]

ConditionalFormattingIcon.Type property

Gets and sets the icon set type. The value of the property is IconSetType integer constant.

Type: Number

ConditionalFormattingIcon.Index property

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

Type: Number

getIconImageData(type, index)

Get the icon set data

ParameterTypeDescription
typeNumberA IconSetType value. icon’s type
indexNumbericon’s index

getImageData(cell)

Gets the image data with the setting of cell.

ParameterTypeDescription
cellCellThe setting of cell.

Returns: Returns the image data of icon.