SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getSparkline Method
The row index.
The column index.
In This Topic
    getSparkline Method
    In This Topic
    Gets the sparkline for the specified cell.
    Syntax
    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.
    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);
    See Also

    Reference

    Worksheet type