SpreadJS Documentation
Binding to Columns
SpreadJS Documentation > Sample Code > Sample Code for Data Binding > Binding to Columns

You can bind to specific columns.

Using Code

This example binds the columns.

JavaScript
Copy Code
$(document).ready(function () {
    var spread = new GcSpread.Sheets.Spread($("#ss").get(0),{sheetCount:3});
    var activeSheet = spread.getActiveSheet();

    //Deactivate automatic column generation while binding.
    activeSheet.autoGenerateColumns = false;

    //Create a data table manually.
    var sampleTable = [
        {"ID":10, "Text":"Text-10", "Check":true},
        {"ID":20, "Text":"Text-20", "Check":false},
        {"ID":30, "Text":"Text-30", "Check":false},
        {"ID":40, "Text":"Text-40", "Check":true},
        {"ID":50, "Text":"Text-50", "Check":true}
    ];

    //Bind the data table
    activeSheet.setDataSource(sampleTable);

    //Bind only specific fields.
    activeSheet.bindColumn(0, "Check");
    activeSheet.bindColumn(1, "ID");

    activeSheet.setColumnCount(2);
});
See Also

Developer's Guide

Binding to Data

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.