API / interfaces / aoa2sheetopts

Interface: AOA2SheetOpts

Options for creating a worksheet from a 2D array (Array of Arrays)

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

cellStyles

optional

cellStyles: boolean

If true, include style/theme information on cells

password

optional

password: string

Workbook password for encrypted files

dense

optional

dense: boolean

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

sheetStubs

optional

sheetStubs: boolean

If true, include stub cells for null/undefined values

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

AutoFilterInfo →