setDataSource Method

Sets the data source that populates the sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.setDataSource(data, reset);

function setDataSource( 
   data : Object,
   reset : boolean
) : any;

Parameters

data: The data source.
reset: true if the sheet is reset; otherwise, false.

Example

This example automatically sets the data types for the cells when binding the sheet.

Javascript

var activeSheet = spread.getActiveSheet();

var people = [
    {name: "Albert", isAdult: false, country: "American", website: "albert.com"},
    {name: "Alice", isAdult: true, country: "China", website: "alice.com"},
    {name: "Bob", isAdult: false, country: "Canada", website: "bob.com"}
];

activeSheet.setDataSource(people);

This example sets a data source for the sheet.

Javascript

var test = [
{"Series0":2,"Series1":1},
{"Series0":4,"Series1":2},
{"Series0":3,"Series1":4}
];
sheet.autoGenerateColumns=true;
sheet.setDataSource(test, true);

Reference

Sheet type