SpreadJS製品ヘルプ
getNamedStyles メソッド
GC.Spread.Sheets 名前空間 > Workbook タイプ : getNamedStyles メソッド
Workbookから名前付きスタイルを取得します。
シンタックス
var instance = new GC.Spread.Sheets.Workbook(host,
                                            options,
                                            options.sheetCount,
                                            options.font,
                                            options.allowUserDragMerge,
                                            options.allowUserDragDrop,
                                            options.allowUserDragFill,
                                            options.allowUserZoom,
                                            options.allowUserResize,
                                            options.allowUndo,
                                            options.allowSheetReorder,
                                            options.allowContextMenu,
                                            options.allowUserDeselect,
                                            options.defaultDragFillType,
                                            options.showDragFillSmartTag,
                                            options.showHorizontalScrollbar,
                                            options.showVerticalScrollbar,
                                            options.scrollbarShowMax,
                                            options.scrollbarMaxAlign,
                                            options.tabStripVisible,
                                            options.tabStripRatio,
                                            options.tabEditable,
                                            options.newTabVisible,
                                            options.tabNavigationVisible,
                                            options.cutCopyIndicatorVisible,
                                            options.cutCopyIndicatorBorderColor,
                                            options.backColor,
                                            options.backgroundImage,
                                            options.backgroundImageLayout,
                                            options.grayAreaBackColor,
                                            options.showResizeTip,
                                            options.showDragDropTip,
                                            options.showDragFillTip,
                                            options.showScrollTip,
                                            options.scrollIgnoreHidden,
                                            options.highlightInvalidData,
                                            options.useTouchLayout,
                                            options.hideSelection,
                                            options.resizeZeroIndicator,
                                            options.allowUserEditFormula,
                                            options.enableFormulaTextbox,
                                            options.autoFitType,
                                            options.referenceStyle,
                                            options.calcOnDemand,
                                            options.allowCopyPasteExcelStyle,
                                            options.allowExtendPasteRange,
                                            options.copyPasteHeaderOptions,
                                            options.scrollByPixel,
                                            options.scrollPixel,
                                            options.allowAutoCreateHyperlink,
                                            options.columnResizeMode,
                                            options.rowResizeMode,
                                            options.customList,
                                            options.scrollbarAppearance);
var value; // Type: any
value = instance.getNamedStyles();
function getNamedStyles() : any;

戻り値の型

名前付きスタイルを含むGC.Spread.Sheets.Styleの配列。
使用例
次のサンプルコードは、getNamedStylesメソッドを使用します。
var namedStyle1 = new GC.Spread.Sheets.Style();
namedStyle1.name = "style2";
namedStyle1.backColor = "blue";

var namedStyle = new GC.Spread.Sheets.Style();
namedStyle.name = "style1";
namedStyle.backColor = "green";
spread.addNamedStyle(namedStyle);
spread.addNamedStyle(namedStyle1);
activeSheet.setStyleName(1, 1, "style1"); 
activeSheet.setStyleName(2, 1, "style1");
 activeSheet.setStyleName(3, 0, "style2");
activeSheet.getCell(1,1).value("test");

var sname = spread.getNamedStyles();
for(var i = 0; i < sname.length; i++){
alert(sname[i].name);
}
var namedStyle1 = new GC.Spread.Sheets.Style();
namedStyle1.name = "style2";
namedStyle1.backColor = "blue";

var namedStyle = new GC.Spread.Sheets.Style();
namedStyle.name = "style1";
namedStyle.backColor = "green";
spread.addNamedStyle(namedStyle);
spread.addNamedStyle(namedStyle1);
activeSheet.setStyleName(1, 1, "style1"); 
activeSheet.setStyleName(2, 1, "style1");
 activeSheet.setStyleName(3, 0, "style2");
activeSheet.getCell(1,1).value("test");

var sname = spread.getNamedStyles();
for(var i = 0; i < sname.length; i++){
alert(sname[i].name);
}
関連トピック

参照

Workbook タイプ