Sparkline
Contents
[
Hide
]Sparkline class
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
class Sparkline;
Methods
| Method | Description |
|---|---|
| getDataRange() | Represents the data range of the sparkline. |
| setDataRange(string) | Represents the data range of the sparkline. |
| getRow() | Gets the row index of the sparkline. |
| getColumn() | Gets the column index of the sparkline. |
| toImage(string, ImageOrPrintOptions) | Converts a sparkline to an image. |
| toImage(ImageOrPrintOptions) | Converts a sparkline to an image. |
| isNull() | Checks whether the implementation object is null. |
getDataRange()
Represents the data range of the sparkline.
getDataRange() : string;
setDataRange(string)
Represents the data range of the sparkline.
setDataRange(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getRow()
Gets the row index of the sparkline.
getRow() : number;
getColumn()
Gets the column index of the sparkline.
getColumn() : number;
toImage(string, ImageOrPrintOptions)
Converts a sparkline to an image.
toImage(fileName: string, options: ImageOrPrintOptions) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| fileName | string | The image file name. |
| options | ImageOrPrintOptions | The image options |
toImage(ImageOrPrintOptions)
Converts a sparkline to an image.
toImage(options: ImageOrPrintOptions) : Uint8Array;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| options | ImageOrPrintOptions | The image options. |
Returns
The result stream
isNull()
Checks whether the implementation object is null.
isNull() : boolean;