API / interfaces / sheet2jsonopts

Interface: Sheet2JSONOpts

Options for converting a worksheet to an array of JSON objects

Properties

header

optional

header: number | string[] | "A"

"A" for column-letter keys, number for 1-indexed row keys, string[] for custom headers

range

optional

range: any

Restrict output to a specific range (Range object, A1 string, or row number)

blankrows

optional

blankrows: boolean

If true, include blank rows in output

defval

optional

defval: any

Default value for missing cells

raw

optional

raw: boolean

If true, use raw values (v) instead of formatted text (w)

skipHidden

optional

skipHidden: boolean

If true, skip hidden rows and columns

rawNumbers

optional

rawNumbers: boolean

If true, emit raw numeric values for non-date number cells

UTC

optional

UTC: boolean

If true, interpret dates as UTC

dateNF

optional

dateNF: NumberFormat

Override date format for date cells

Source

src/types.ts

← Sheet2HTMLOpts | SheetProps →