CellDirective API in Angular Spreadsheet API component

e-cell directive represent a cell of the Angular Spreadsheet. It must be contained in a e-row directive.

<ejs-spreadsheet>
  <e-sheets>
   <e-sheet>
   <e-rows>
   <e-row>
   <e-cells>
   <e-cell value='A1'></e-cell>
   </e-cells>
   </e-row>
   </e-rows>
   </e-sheet>
  </e-sheets>
</ejs-spreadsheet>

Properties

chart

any

Specifies the chart of the cell.

Defaults to []

colSpan

any

Specifies the column-wise cell merge count.

Defaults to 1

format

any

Specifies the number format code to display value in specified number format.

Defaults to ‘General’

formula

any

Defines the formula or expression of the cell.

Defaults to ”

hyperlink

any

Specifies the hyperlink of the cell.

Defaults to ”

image

any

Specifies the image of the cell.

Defaults to []

index

any

Specifies the index of the cell.

Defaults to 0

isLocked

any

Specifies the cell is locked or not, for allow edit range in spreadsheet protect option.

Defaults to true

rowSpan

any

Specifies the row-wise cell merge count.

Defaults to 1

style

any

Specifies the cell style options.

Defaults to {}

validation

any

Specifies the validation of the cell.

Defaults to ”

value

any

Defines the value of the cell which can be text or number.

Defaults to ”

wrap

any

Wraps the cell text to the next line, if the text width exceeds the column width.

Defaults to false