ConditionalFormattingIcon

ConditionalFormattingIcon class

Represents the custom icon of conditional formatting rule.

Properties

NameTypeDescription
ImageDatabyte[]Gets the icon set data.
TypeintGets and sets the icon set type. The value of the property is IconSetType integer constant.
IndexintGets 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: int

ConditionalFormattingIcon.Index property

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

Type: int

getIconImageData(type, index)

Get the icon set data

ParameterTypeDescription
typeintA IconSetType value. icon’s type
indexinticon’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.