Search results

Row API in JavaScript Spreadsheet API control

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