Configures the Row behavior for the spreadsheet.
<div id='Spreadsheet'></div>
let spreadsheet: Spreadsheet = new Spreadsheet({
sheets: [{
rows: [{
index: 30,
cells: [{ index: 4, value: 'Total Amount:' },
{ formula: '=SUM(F2:F30)', style: { fontWeight: 'bold' } }]
}]
...
});
spreadsheet.appendTo('#Spreadsheet');
Specifies cell and its properties for the row.
Defaults to []
boolean
specifies custom height of the row.
Defaults to false
Specifies format of the row.
Defaults to {}
number
Specifies height of the row.
Defaults to 20
boolean
To hide/show the row in spreadsheet.
Defaults to false
number
Specifies the index to the row. Based on the index, row properties are applied.
Defaults to 0
boolean
Represents whether a row in the sheet is read-only or not. If set to true, it prevents editing the specified cell in the sheet.
Defaults to false