SpreadJS Documentation
Using the Worksheet Element
SpreadJS Documentation > Developer's Guide > Working with JavaScript Frameworks > Using SpreadJS with React > Using the Worksheet Element

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