getNamedStyles Method

Gets named styles from the Worksheet.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

Javascript

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);
}

Reference

Worksheet type