Methods

getAxisColor()

Gets the color of the axis for cells with conditional formatting as data bars.

getAxisPosition()

Gets or sets the position of the axis of the data bars specified by a conditional formatting rule. The value of the property is DataBarAxisPosition integer constant.

getBarBorder()

Gets an object that specifies the border of a data bar.

getBarFillType()

Gets or sets how a data bar is filled with color. The value of the property is DataBarFillType integer constant.

getColor()

Get or set this DataBar's Color.

getDirection()

Gets or sets the direction the databar is displayed. The value of the property is TextDirectionType integer constant.

getMaxCfvo()

Get or set this DataBar's max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.

getMaxLength()

Represents the max length of data bar .

getMinCfvo()

Get or set this DataBar's min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.

getMinLength()

Represents the min length of data bar .

getNegativeBarFormat()

Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.

getShowValue()

Get or set the flag indicating whether to show the values of the cells on which this data bar is applied. Default value is true.

setAxisColor()

Gets the color of the axis for cells with conditional formatting as data bars.

setAxisPosition()

Gets or sets the position of the axis of the data bars specified by a conditional formatting rule. The value of the property is DataBarAxisPosition integer constant.

setBarFillType()

Gets or sets how a data bar is filled with color. The value of the property is DataBarFillType integer constant.

setColor()

Get or set this DataBar's Color.

setDirection()

Gets or sets the direction the databar is displayed. The value of the property is TextDirectionType integer constant.

setMaxLength()

Represents the max length of data bar .

setMinLength()

Represents the min length of data bar .

setShowValue()

Get or set the flag indicating whether to show the values of the cells on which this data bar is applied. Default value is true.

toImage(cell, imgOpts) → Array of byte

Render data bar in cell to image byte array.

Parameters

Name Type Optional Description

cell

Cell

 

Indicate the data bar in which cell to be rendered

imgOpts

ImageOrPrintOptions

 

ImageOrPrintOptions contains some property of output image

Returns

Array of byte