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

    Parameters

    row
    The row index.
    column
    The column index.
    value
    The name of the style to set.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.
    Example
    This example creates a named style.
    <input type="button" id="button1" value="button1"/>
    
    var namedStyle = new GC.Spread.Sheets.Style();
    namedStyle.name = "style1";
    namedStyle.backColor = "green";
    activeSheet.addNamedStyle(namedStyle);
    activeSheet.setStyleName(1, 1, "style1"); // cell(1,1)'s backColor is  green.
    activeSheet.setStyleName(2, 1, "style1");
     
    var style = activeSheet.getNamedStyle("style1");
    style.foreColor = "red";    // the namedStyle's foreColor is red.
    activeSheet.repaint(); // the foreColor of the cell(1,1) and cell(2,1) is red.
    activeSheet.getCell(1,1).value("test");
    
    $("#button1").click(function () {
    activeSheet.removeNamedStyle("style1");
        });
    See Also

    Reference

    Worksheet type