Input data encoding

Default codepage for legacy files

This requires encoding support to be loaded. It is automatically loaded in xlsx.full.min.js and in CommonJS / Extendscript, but an extra step is required in React / Angular / Webpack ESM deployments.

Check the relevant guide https://docs.sheetjs.com/docs/getting-started/

Save formulae to the .f field

Parse rich text and save HTML to the .h field

Save number format string to the .z field

Generate formatted text to the .w field

Override default date format (code 14)

Field Separator ("Delimiter" override)

If >0, read the first sheetRows rows

If true, parse calculation chains

If true, add raw files to book object

If true, only parse enough to get book metadata

If true, only parse enough to get the sheet names

If specified, only parse the specified sheets or sheet names

If true, plaintext parsing will not parse values

If true, ignore "dimensions" records and guess range using every cell

If true, preserve _xlfn. prefixes in formula function names

For single-sheet formats (including CSV), override the worksheet name