Sparkline

Sparkline class

A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.

Properties

NameTypeDescription
DataRangeStringRepresents the data range of the sparkline.
RowNumberGets the row index of the sparkline.
ColumnNumberGets the column index of the sparkline.

Methods

NameDescription
toImageConverts a sparkline to an image.

Sparkline.DataRange property

Represents the data range of the sparkline.

Type: String

Sparkline.Row property

Gets the row index of the sparkline.

Type: Number

Sparkline.Column property

Gets the column index of the sparkline.

Type: Number

toImage(fileName, options) (1 of 2)

Converts a sparkline to an image.

ParameterTypeDescription
fileNameStringThe image file name.
optionsImageOrPrintOptionsThe image options

toImage(stream, options) (2 of 2)

Converts a sparkline to an image.

ParameterTypeDescription
streamOutputStreamThe image stream.
optionsImageOrPrintOptionsThe image options.