Interface for a class Sheet
string
Specifies active cell within selectedRange
in the sheet.
number
Defines the number of columns to be rendered in the sheet.
Configures column and its properties for the sheet.
Specifies the conditional formatting for the sheet.
number
Gets or sets the number of frozen columns.
number
Gets or sets the number of frozen rows.
number
Specifies index of the sheet. Based on the index, sheet properties are applied.
boolean
Specifies to protect the cells in the sheet.
string
Specifies the name of the sheet, the name will show in the sheet tabs.
string
Represents the freeze pane top left cell. Its default value would be based on the number of freeze rows and columns.
string
Specifies the password.
Configures protect and its options.
Specifies the collection of range for the sheet.
number
Defines the number of rows to be rendered in the sheet.
Configures row and its properties for the sheet.
string
Specifies selected range in the sheet.
<div id='Spreadsheet'></div>
let spreadsheet: Spreadsheet = new Spreadsheet({
sheets: [{
selectedRange: 'A1:B5'
}],
...
});
spreadsheet.appendTo('#Spreadsheet');
boolean
Specifies to show / hide grid lines in the sheet.
boolean
Specifies to show / hide column and row headers in the sheet.
Specifies the sheet visibility state. There must be at least one visible sheet in Spreadsheet.
string
Specified cell will be positioned at the upper-left corner of the sheet.
Defines the used range of the sheet.