API / interfaces / json2sheetopts

Interface: JSON2SheetOpts

Options for creating a worksheet from an array of JSON objects

Hierarchy

Extends:

• CommonOptions

Properties

WTF

optional

WTF: boolean

If true, throw errors on unexpected situations instead of silently recovering

bookVBA

optional

bookVBA: boolean

If true, expose VBA macro data in workbook.vbaraw

sheetStubs

optional

sheetStubs: boolean

If true, include stub cells for empty cells within the used range

cellStyles

optional

cellStyles: boolean

If true, include style/theme information on cells

password

optional

password: string

Workbook password for encrypted files

header

optional

header: string[]

Explicit header row keys (overrides object key order)

skipHeader

optional

skipHeader: boolean

If true, do not emit a header row

dense

optional

dense: boolean

If true, use dense (2D array) storage mode

dateNF

optional

dateNF: NumberFormat

Date format string for date cells

cellDates

optional

cellDates: boolean

If true, store dates as Date objects instead of serial numbers

UTC

optional

UTC: boolean

If true, interpret dates as UTC

date1904

optional

date1904: boolean

If true, use 1904 date system for date serial numbers

origin

optional

origin: string | number | CellAddress

Starting cell for data: row number, A1 reference, or CellAddress

nullError

optional

nullError: boolean

If true, convert null values to #NULL! error cells

Source

src/types.ts

← Hyperlink | MarginInfo →