SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Cells / Setting Cell Values
In This Topic
    Setting Cell Values
    In This Topic

    You can put values in the cells.

    Cell values

    Using Code

    This example sets cell values.

    JavaScript
    Copy Code
    $(document).ready(function ()
    {
        var spread =
        new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
        var sheet = spread.getActiveSheet();
        sheet.getCell(0, 0).formatter("0.00_);(0.00)");
        sheet.getCell(1, 0).formatter("0.00_);(0.00)");
        sheet.getCell(0, 1).formatter("0.00_);(0.00)");
        sheet.getCell(1, 1).formatter("0.00_);(0.00)");
       
        // Set values to Text property
        sheet.getCell(0, 0).text("10");
       
        //Set values by calling SetText method
        sheet.setText(1, 0, "10");
       
        //Set values to Value property.
        sheet.getCell(0, 1).value(10);
       
        //Set values by calling SetValue method.
        sheet.setValue(1, 1, 10);
    });