SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getNamedStyles Method
In This Topic
    getNamedStyles Method
    In This Topic
    Gets named styles from the Worksheet.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.getNamedStyles();
    function getNamedStyles() : any;

    Return Value

    The GC.Spread.Sheets.Style array of named styles.
    Example
    This example uses the getNamedStyles method.
    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");
    
    var sname = activeSheet.getNamedStyles();
    for(var i = 0; i < sname.length; i++){
    alert(sname[i].name);
    }
    See Also

    Reference

    Worksheet type