Spread.Sheets
Worksheet要素の使用

次の表は、sheet要素の属性を示します。

属性 APIリファレンス コメント
dataSource Worksheet.setDataSource(value) any  
name Worksheet.name(value) string  
frozenColumnCount Worksheet.frozenColumnCount(value) number  
frozenRowCount Worksheet.frozenRowCount(value) number  
frozenTrailingColumnCount Worksheet.frozenTrailingColumnCount(value) number  
frozenTrailingRowCount Worksheet.frozenTrailingRowCount(value) number  
allowCellOverflow Worksheet.options.allowCellOverflow = value boolean  
frozenlineColor Worksheet.options.frozenlineColor = value string
sheetTabColor Worksheet.options.sheetTabColor = value string  
rowCount Worksheet.setRowCount(value) number  
colCount Worksheet.setColumnCount(value) number  
selectionPolicy Worksheet.selectionPolicy(value) GC.Spread.Sheets.SelectionPolicy  
selectionUnit Worksheet.selectionUnit(value) GC.Spread.Sheets.SelectionUnit  
zoom Worksheet.zoom(value) number  
currentTheme Worksheet.currentTheme(value) string  
clipBoardOptions Worksheet.options.clipBoardOptions(value) GC.Spread.Sheets.ClipboardPasteOptions  
rowHeaderVisible Worksheet.options.rowHeaderVisible = value boolean  
columnHeaderVisible Worksheet.options.colHeaderVisible = value boolean  
rowHeaderAutoText Worksheet.options.rowHeaderAutoText = value GC.Spread.Sheets.HeaderAutoText  
columnHeaderAutoText Worksheet.options.colHeaderAutoText = value GC.Spread.Sheets.HeaderAutoText  
rowHeaderAutoTextIndex Worksheet.options.rowHeaderAutoTextIndex = value number  
columnHeaderAutoTextIndex Worksheet.options.colHeaderAutoTextIndex = value number  
isProtected Worksheet.options.isProtected = value boolean  
showRowOutline Worksheet.showRowOutline(value) boolean  
showColumnOutline Worksheet.showColumnOutline(value) boolean  
selectionBackColor Worksheet.options.selectionBackColor = value string  
selectionBorderColor Worksheet.options.selectionBorderColor = value string  
defaultStyle Worksheet.setDefaultStyle(value) GC.Spread.Sheets.Style  
rowOutlineInfo any[] 行アウトライン情報を保持する配列。例:[{index:1,count:10}]
columnOutlineInfo any[] 列アウトライン情報を保持する配列。例:[{index:1,count:10}]

次の表は、worksheet要素の子要素を示します。

子要素 カウント
Column any

 

 


© 2016-2018, GrapeCity inc. All rights reserved.