Column

23 Sep 20251 minute to read

Configures the Column behavior for the spreadsheet.

Properties

customWidth boolean

specifies custom width of the column.

Defaults to false

format FormatModel

Specifies format of the column.

Defaults to {}

hidden boolean

To hide/show the column in spreadsheet.

Defaults to false

index number

Specifies index of the column. Based on the index, column properties are applied.

Defaults to 0

isLocked boolean

To lock/unlock the column in the protected sheet.

Defaults to true

isReadOnly boolean

Represents whether a column in the sheet is read-only or not. If set to true, it prevents editing the specified cell in the sheet.

Defaults to false

validation ValidationModel

Specifies the validation of the column.

Defaults to ’’

width number

Specifies width of the column.

Defaults to 64