class
Sparkline
Source: aspose.
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
Methods
getColumn()
Gets the column index of the sparkline.
getDataRange()
Represents the data range of the sparkline.
getRow()
Gets the row index of the sparkline.
setDataRange()
Represents the data range of the sparkline.
toImage(fileName, options)
Converts a sparkline to an image.
Parameters
Name | Type | Optional | Description |
---|---|---|---|
fileName |
String |
|
The image file name. |
options |
|
The image options |
toImage(stream, options)
Converts a sparkline to an image.
Parameters
Name | Type | Optional | Description |
---|---|---|---|
stream |
OutputStream |
|
The image stream. |
options |
|
The image options. |
static
toImageStream(sparkline, stream, options)
Converts a sparkline to an image.
Example
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var fs = require("fs");
var workbook = new aspose.cells.Workbook("sparkline.xlsx");
var sparkline = workbook.getWorksheets().get(0).getSparklineGroupCollection().get(0).getSparklineCollection().get(0);
var imgWriteStream = fs.createWriteStream("sparkline.jpeg");
var imgOptions = new aspose.cells.ImageOrPrintOptions();
imgOptions.setHorizontalResolution(200);
imgOptions.setVerticalResolution(300);
imgOptions.setImageFormat(aspose.cells.ImageFormat.getJpeg());
aspose.cells.Sparkline.toImageStream(sparkline, imgWriteStream, imgOptions);
Parameters
Name | Type | Optional | Description |
---|---|---|---|
sparkline |
|
The Sparkline object |
|
stream |
WritableStream |
|
The stream of the output image |
options |
|
Addtional image creation options |