SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setText Method
The row index.
The column index.
The text for the specified cell.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    setText Method
    In This Topic
    Sets the formatted text in the cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setText(row, col, value, sheetArea);
    function setText( 
       row : number,
       col : number,
       value : string,
       (optional) sheetArea : SheetArea
    ) : any;

    Parameters

    row
    The row index.
    col
    The column index.
    value
    The text for the specified cell.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.
    Example
    This example uses the setText method.
    //Set values to Text property
    activeSheet.getCell(0, 0).text("10");
    //Set values by calling SetText method
    activeSheet.setText(1, 0, "10");
    //Set values to Value property.
    activeSheet.getCell(0, 1).value(10);
    //Set values by calling SetValue method.
    activeSheet.setValue(1, 1, 10);
    
        $("#button1").click(function(){
            alert("Obtaining cell values by referring to Text property: " + activeSheet.getCell(0, 0).text() + "\n" +
                "Obtaining cell values by calling GetText method: " + activeSheet.getText(1, 0) + "\n" +
                "Obtaining cell values by referring to Value property: " + activeSheet.getCell(0, 1).value() + "\n" +
                "Obtaining cell values by calling GetValue method: " + activeSheet.getValue(1, 1));
    });
    
    //Add button control to page
    <input type="button" id="button1" value="button1"/>
    See Also

    Reference

    Worksheet type