Interface: Sheet2CSVOpts

Options for converting a worksheet to CSV

Hierarchy

Extends:

• WorksheetCellBudgetOptions Extended by:
• WriteOptions

Properties

maxWorksheetCells

optional

maxWorksheetCells: number

Maximum cumulative cell work per sheet. This counts explicit cells plus generated column, hyperlink, span, and export positions. XLSX reads default to 10,000,000; exports default to 1,000,000.

FS

optional

FS: string

Field separator (default: ",")

RS

optional

RS: string

Record separator / row delimiter (default: "\n")

strip

optional

strip: boolean

If true, strip trailing field separators from each row

blankrows

optional

blankrows: boolean

If true, include blank rows (default: true)

skipHidden

optional

skipHidden: boolean

If true, skip hidden rows and columns

forceQuotes

optional

forceQuotes: boolean

If true, wrap all fields in quotes

rawNumbers

optional

rawNumbers: boolean

If true, emit raw numeric values instead of formatted text

escapeFormulae

optional

escapeFormulae: boolean

If not false, prefix formula-like text fields with a single quote

dateNF

optional

dateNF: NumberFormat

Override date format for date cells

dateOutput

optional

dateOutput: "iso"

If "iso", emit date/datetime cells as machine-readable ISO-like strings

UTC

optional

UTC: boolean

If true, interpret dates as UTC

date1904

optional

date1904: boolean

If true, use 1904 date system for date serial numbers

Source

src/types.ts:547

← Sheet | Sheet2HTMLOpts →