Cell API in JavaScript (ES5) Spreadsheet API control

Represents the cell.

Properties

chart

ChartModel[]

Specifies the chart of the cell.

Defaults to []

colSpan

number

Specifies the column-wise cell merge count.

Defaults to 1

format

string

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

Defaults to ‘General’

formula

string

Defines the formula or expression of the cell.

Defaults to ”

hyperlink

string | HyperlinkModel

Specifies the hyperlink of the cell.

Defaults to ”

image

ImageModel[]

Specifies the image of the cell.

Defaults to []

index

number

Specifies the index of the cell.

Defaults to 0

isLocked

boolean

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

Defaults to true

isReadOnly

boolean

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

Defaults to false

notes

string

Specifies the note of the cell.

Defaults to ”

rowSpan

number

Specifies the row-wise cell merge count.

Defaults to 1

style

CellStyleModel

Specifies the cell style options.

<div id='Spreadsheet'></div>

let spreadsheet: Spreadsheet = new Spreadsheet({
     sheets: [{
      ...
           rows: [{
                 cells: [{ value: '12', index: 2,  style: { fontWeight: 'bold', fontSize: 12, fontStyle: 'italic', textIndent: '2pt'
                        backgroundColor: '#4b5366', color: '#ffffff' } }]
                 }]
           }]
 });
spreadsheet.appendTo('#Spreadsheet');

Defaults to {}

validation

ValidationModel

Specifies the validation of the cell.

Defaults to ”

value

string

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

Defaults to ”

wrap

boolean

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

Defaults to false