XLSX is the exposed variable in the browser and the exported node variable
XLSX.version is the version of the library (added by the build script).
XLSX.SSF is an embedded version of the format library.
XLSX.read(data, read_opts) attempts to parse
XLSX.readFile(filename, read_opts) attempts to read
filename and parse.
Parse options are described in the Parsing Options section.
XLSX.write(wb, write_opts) attempts to write the workbook
XLSX.writeFile(wb, filename, write_opts) attempts to write
In browser-based environments, it will attempt to force a client-side download.
XLSX.writeFileAsync(wb, filename, o, cb) attempts to write
o is omitted, the writer will use the third argument as the callback.
XLSX.stream contains a set of streaming write functions.
Write options are described in the Writing Options section.
Utilities are available in the
XLSX.utils object and are described in the
Utility Functions section:
book_newcreates an empty workbook
book_append_sheetadds a worksheet to a workbook
aoa_to_sheetconverts an array of arrays of JS data to a worksheet.
json_to_sheetconverts an array of JS objects to a worksheet.
table_to_sheetconverts a DOM TABLE element to a worksheet.
sheet_add_aoaadds an array of arrays of JS data to an existing worksheet.
sheet_add_jsonadds an array of JS objects to an existing worksheet.
sheet_to_jsonconverts a worksheet object to an array of JSON objects.
sheet_to_csvgenerates delimiter-separated-values output.
sheet_to_txtgenerates UTF16 formatted text.
sheet_to_htmlgenerates HTML output.
sheet_to_formulaegenerates a list of the formulae (with value fallbacks).
Cell and cell address manipulation:
format_cellgenerates the text value for a cell (using number formats).
encode_row / decode_rowconverts between 0-indexed rows and 1-indexed rows.
encode_col / decode_colconverts between 0-indexed columns and column names.
encode_cell / decode_cellconverts cell addresses.
encode_range / decode_rangeconverts cell ranges.