ColumnDirective API in Angular Spreadsheet API component

e-column directive represent a column of the Angular Spreadsheet. It must be contained in a e-sheet directive.

<ejs-spreadsheet>
  <e-sheets>
   <e-sheet>
   <e-columns>
   <e-column width='100'></e-column>
   </e-columns>
   </e-sheet>
  </e-sheets>
</ejs-spreadsheet>

Properties

customWidth

any

specifies custom width of the column.

Defaults to false

format

any

Specifies format of the column.

Defaults to {}

hidden

any

To hide/show the column in spreadsheet.

Defaults to false

index

any

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

Defaults to 0

isLocked

any

To lock/unlock the column in the protected sheet.

Defaults to true

isReadOnly

any

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

any

Specifies the validation of the column.

Defaults to ”

width

any

Specifies width of the column.

Defaults to 64