Spread.Sheets Documentation
getNamedStyles Method
Gets named styles from the Worksheet.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: Array
value = instance.getNamedStyles();
function getNamedStyles() : Array;

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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.