Spread.Sheets Documentation
Understanding the Worksheet Element

The following table lists the gc-worksheet elements:

Attribute Spread.Sheets API 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.setRowHeaderVisible = 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 information, such as [{index: 1, count: 10}].
columnOutlineInfo   any [ ] An array that contains row outline information, such as [{index: 1, count: 10}].

 The following example uses the worksheet element:

JavaScript
Copy Code
@Component({
      selector: 'my-app',
      template: `<gc-spread-sheets>
                      <gc-worksheet [name]="sheetName" [rowOutlineInfo]="rowOutlineInfo">
                      </gc-worksheet>
                 </gc-spread-sheets>`,
    })
    export class AppComponent {
      sheetName: "SheetName";
      rowOutlineInfo = {
          index: 1,
          count: 3
      }
    }

The worksheet element has the following child element:

Child Element Spread.Sheets API Count
gc-column   any

 

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.