[]
        
(Showing Draft Content)

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