data Method

Gets or sets the data object.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sparkline(row, column, dataReference, dataOrientation, type, setting);
var returnValue; // Type: Range
returnValue = instance.data(value);

function data( 
   value : Range
) : Range;

Parameters

value: The sparkline data.

Return Value

The sparkline data.

Example

This example uses the data method.

Javascript

activeSheet.isPaintSuspended(true);
activeSheet.setValue(1, 0, 10);
activeSheet.setValue(2, 0, 0);
activeSheet.setValue(3, 0, -3);
activeSheet.setValue(4, 0, -5);
activeSheet.setValue(0, 0, 1);
activeSheet.setValue(0, 1, 2);
activeSheet.setValue(0, 2, 4);
activeSheet.setValue(0, 3, 8);
activeSheet.setValue(0, 4, 6);
activeSheet.setValue(0, 5, new Date(2014, 1, 1));
activeSheet.setValue(1, 5, new Date(2014, 9, 1));
activeSheet.setValue(2, 5, new Date(2014, 7, 1));
activeSheet.setValue(3, 5, new Date(2014, 5, 1));
activeSheet.setValue(4, 5, new Date(2014, 3, 1));
var sparkline = activeSheet.setSparkline(5, 0, new GcSpread.Sheets.Range(0, 0, 5, 5), GcSpread.Sheets.DataOrientation.Horizontal, GcSpread.Sheets.SparklineType.line, new GcSpread.Sheets.SparklineSetting(), new GcSpread.Sheets.Range(0, 5, 5, 1), GcSpread.Sheets.DataOrientation.Vertical);
sparkline.data(new GcSpread.Sheets.Range(0, 0, 5, 5));
sparkline.sparklineType(GcSpread.Sheets.SparklineType.line);
sparkline.setting(new GcSpread.Sheets.SparklineSetting());
sparkline.dateAxisData(new GcSpread.Sheets.Range(0, 5, 5, 1));
sparkline.dataOrientation(GcSpread.Sheets.DataOrientation.Vertical);
sparkline.dateAxisOrientation(GcSpread.Sheets.DataOrientation.Vertical);
sparkline.row = 5;
sparkline.column = 0;
sparkline.displayDateAxis(true); 
activeSheet.isPaintSuspended(false);

Reference

Sparkline class