The following table lists the attributes of the sheet element.
Attribute | API Reference | Type | Comment |
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[] | An array that contains row outline infos, such as [{index:1,count:10}) | |
columnOutlineInfo | any[] | An array that contains column outline infos, such as [{index:1,count:10}) |
The following table lists the child elements of the worksheet.
Child Element | Count |
Column | any |