Row

23 Sep 20251 minute to read

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');

Properties

cells CellModel[]

Specifies cell and its properties for the row.

Defaults to []

customHeight boolean

specifies custom height of the row.

Defaults to false

format FormatModel

Specifies format of the row.

Defaults to {}

height number

Specifies height of the row.

Defaults to 20

hidden boolean

To hide/show the row in spreadsheet.

Defaults to false

index number

Specifies the index to the row. Based on the index, row properties are applied.

Defaults to 0

isReadOnly 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