Column API in Vue Spreadsheet API component

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