getSparkline Method

Gets the sparkline for the specified cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: GC.Spread.Sheets.Sparkline
value = instance.getSparkline(row, col);

function getSparkline( 
   row : number,
   col : number
) : GC.Spread.Sheets.Sparkline;

Parameters

row: The row index.
col: The column index.

Return Value

The sparkline for the cell.

Example

This example creates and gets a sparkline.

Javascript

var cellr = new GC.Spread.Sheets.Range(0, 0, 1, 5);
var ex = new GC.Spread.Sheets.Sparklines.SparklineSetting();
ex.options.SeriesColor  = "Aquamarine";
sheet.setValue(0, 0, 2);
sheet.setValue(0, 1, 5);
sheet.setValue(0, 2, 4);
sheet.setValue(0, 3, -1);
sheet.setValue(0, 4, 3);
sheet.setSparkline(0, 5, cellr, GC.Spread.Sheets.Sparklines.DataOrientation.horizontal, GC.Spread.Sheets.Sparklines.SparklineType.column, ex);
alert(sheet.getSparkline(0, 5).toString());
//sheet.removeSparkline(0, 5);

Reference

Worksheet type