API / interfaces / cellobject

Interface: CellObject

Worksheet Cell Object containing value, format, formula, and metadata

Properties

v

optional

v: string | number | boolean | Date

Raw cell value (string, number, boolean, or Date)

w

optional

w: string

Formatted text representation of the cell value

t

t: ExcelDataType

Cell data type code

f

optional

f: string

Cell formula string (without leading "=")

F

optional

F: string

Range of a shared/array formula (e.g. "A1

D

optional

D: boolean

If true, the formula is a dynamic array formula

r

optional

r: any

Rich text / XML representation

h

optional

h: string

HTML rendering of the cell (when cellHTML option is enabled)

c

optional

c: Comments

Comments attached to this cell

z

optional

z: NumberFormat

Number format string or index

l

optional

l: Hyperlink

Hyperlink on this cell

s

optional

s: any

Style object (when cellStyles option is enabled)

XF

optional

XF: { numFmtId?: number }

Raw XF (extended format) record data

Source

src/types.ts

← CellAddress | ColInfo →