SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setDataSource Method
The data source.
true if the sheet is reset; otherwise, false.
In This Topic
    setDataSource Method
    In This Topic
    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