Spread.Sheets Documentation
setDataSource Method
GC.Spread.Sheets Namespace > Worksheet type : setDataSource Method
The data source.
true if the sheet is reset; otherwise, false.
Sets the data source that populates the sheet.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(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.
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.
var activeSheet = spread.getActiveSheet();

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

Reference

Worksheet type