下表列出了 sheet 标签的子标签。
下表描述了 sheets 标签的子标签。sheet 标签没有属性。
子元素 | API 参考 | 类型 |
worksheet | any | Worksheet |
下表列出了所有 sheet 标签的属性:
属性 | API 参考 | 类型 | 注释 |
allowCellOverflow | Worksheet.options.allowCellOverflow = value | boolean | |
clipBoardOptions | Worksheet.options.clipBoardoptions(value) | GC.Spread.Sheets.ClipboardPasteOptions | |
colHeaderAutoText | Worksheet.options.colHeaderAutoText = value | GC.Spread.Sheets.HeaderAutoText | |
colHeaderAutoTextIndex | Worksheet.options.colHeaderAutoTextIndex = value | number | |
colHeaderVisible | Worksheet.options.colHeaderVisible = value | boolean | |
currentTheme | Worksheet.currentTheme(value) | string | |
dataSource | Worksheet.setDataSource(value) | any | |
dataSourceDeepWatch | boolean | 此属性用于绑定的数据源变化时 Spread.Sheets 的自动刷新。当此属性为 true 时,AngularJS 通知数据源来刷新 Spread.Sheets,否则不刷新。默认值为 true。 | |
frozenColumnCount | Worksheet.frozenColumnCount(value) | number | |
frozenlineColor | Worksheet.options.frozenlineColor = value | string | |
frozenRowCount | Worksheet.frozenRowCount(value) | number | |
frozenTrailingColumnCount | Worksheet.frozenTrailingColumnCount(value) | number | |
frozenTrailingRowCount | Worksheet.frozenTrailingRowCount(value) | number | |
isProtected | Worksheet.options.isProtected = value | boolean | |
name | Worksheet.name(value) | string | |
rowCount | Worksheet.setRowCount(value) | number | |
rowHeaderAutoText | Worksheet.options.rowHeaderAutoText = value | GC.Spread.Sheets.HeaderAutoText | |
rowHeaderAutoTextIndex | Worksheet.options.rowHeaderAutoTextIndex = value | number | |
rowHeaderVisible | Worksheet.options.setRowHeaderVisible = value | boolean | |
selectionBackColor | Worksheet.options.selectionBackColor = value | string | |
selectionBorderColor | Worksheet.options.selectionBorderColor = value | string | |
selectionPolicy | Worksheet.selectionPolicy(value) | GC.Spread.Sheets.SelectionPolicy | |
selectionUnit | Worksheet.selectionUnit(value) | GC.Spread.Sheets.SelectionUnit | |
sheetTabColor | Worksheet.options.sheetTabColor = value | string | |
showColumnOutline | Worksheet.showColumnOutline(value) | boolean | |
showRowOutline | Worksheet.showRowOutline(value) | boolean | |
zoom | Worksheet.zoom(value) | number |
下表列出了 sheet 的子标签
Child Element | API Reference | Count | Type | Comment |
columns | sheet.columns | 1 | columns | columns 标签只能存在于 sheet 标签内。 |
columnOutlines | Worksheet.columnOutlines | 1 | GC.Spread.Sheets.Outlines.Outline | |
columnHeaderDefaultStyle | Worksheet.setDefaultStyle(value, SheetArea.colHeader) | 1 | style | |
defaultStyle | Worksheet.setDefaultStyle(value, SheetArea.viewport) | 1 | style | |
rowHeaderDefaultStyle | Worksheet.setDefaultStyle(value, SheetArea.rowHeader) | 1 | style | |
rowOutlines | Worksheet.rowOutlines | 1 | GC.Spread.Sheets.Outlines.Outline |