This log is intended to keep track of backwards-incompatible changes, including
but not limited to API changes and file location changes. Minor behavioral
changes may not be included if they are not expected to break existing code.
v0.18.2
Hotfix for unicode processing of XLSX exports
v0.18.1
Removed Node ESM build script and folded into standard ESM build
Removed undocumented aliases including make_formulae and get_formulae
v0.18.0
Browser scripts only expose XLSX variable
Module no longer ships with dist/jszip.js browser script
v0.17.4
CLI script moved to xlsx-cli package
v0.17.3
window.XLSX explicit assignment to satiate LWC
CSV Proper formatting of errors
HTML emit data-* attributes
v0.17.2
Browser and Node optional ESM support
DSV correct handling of bare quotes (h/t @bgamrat)
v0.17.1
XLSB writer uses short cell form when viable
0.17.0:
mini build includes ODS parse/write support
DBF explicitly cap worksheet to 1<<20 rows
XLS throw errors on truncated records
v0.16.2
Disabled PRN parsing by default (better support for CSV without delimeters)
v0.16.1
skip empty custom property tags if data is absent (fixes DocSecurity issue)
HTML output add raw value, type, number format
DOM parse look for v / t / z attributes when determining value
double quotes in properties escaped using _x0022_
changed AMD structure for NetSuite and other RequireJS implementations
encode_cell and decode_cell do not rely on encode_col / decode_col
v0.16.0
Date handling changed
XLML certain tag tests are now case insensitive
Fixed potentially vulnerable regular expressions
v0.15.6
CFB prevent infinite loop
ODS empty cells marked as stub (type "z")
cellStyles option implies sheetStubs
v0.15.5
sheets parse option to specify which sheets to parse
v0.15.4
AOA utilities properly preserve number formats
Number formats captured in stub cells
v0.15.3
Properties and Custom Properties properly XML-encoded
v0.15.2
sheet_get_cell utility function
sheet_to_json explicitly support null as alias for default behavior
encode_col throw on negative column index
HTML properly handle whitespace around tags in a run
HTML use id option on write
Files starting with 0x09 followed by a display character are now TSV files
XLS parse references col/row indices mod by the correct number for BIFF ver
XLSX comments moved to avoid overlapping cell
XLSB outline level
AutoFilter update _FilterDatabase defined name on write
XLML skip CDATA blocks
v0.15.1 (2019-08-14)
XLSX ignore XML artifacts
HTML capture and persist merges
v0.15.0
dist/xlsx.mini.min.js mini build with XLSX read/write and some utilities
Removed legacy conversion utility functions
v0.14.5
XLS PtgNameX lookup
XLS always create stub cells for blank cells with comments
v0.14.4
Better treatment of skipHidden in CSV output
Ignore CLSID in XLS
SYLK 7-bit character encoding
SYLK and DBF codepage support
v0.14.3
Proper shifting of addresses in Shared Formulae
v0.14.2
Proper XML encoding of comments
v0.14.1
raw cell objects can be passed to sheet_add_aoa
_FilterDatabase fix for AutoFilter-related crashes
stream.to_json doesn't end up accidentally scanning to max row
0.14.0 (2018-09-06)
sheet_to_json default flipped to raw: true
0.13.5 (2018-08-25)
HTML output generates <br/> instead of encoded newline character
0.13.2 (2018-07-08)
Buffer.from shim replaced, will not be defined in node <=0.12
0.13.0 (2018-06-01)
Library reshaped to support AMD out of the box
0.12.11 (2018-04-27)
XLS/XLSX/XLSB range truncation (errors in WTF mode)
0.12.4 (2018-03-04)
JSZip renamed to JSZipSync
0.12.0 (2018-02-08)
Extendscript target script in NPM package
0.11.19 (2018-02-03)
Error on empty workbook
0.11.16 (2017-12-30)
XLS ANSI/CP separation
'array' write type and ArrayBuffer processing
0.11.6 (2017-10-16)
Semicolon-delimited files are detected
0.11.5 (2017-09-30)
Bower main script shifted to full version
'binary' / 'string' encoding
0.11.3 (2017-08-19)
XLS cell ixfe/XF removed
0.11.0 (2017-07-31)
Strip require statements from minified version
minifier mangler enabled
0.10.9 (2017-07-28)
XLML/HTML resolution logic looks further into the data stream to decide type
Errors thrown on suspected RTF files
0.10.5 (2017-06-09)
HTML Table output header/footer should not include <table> tag
0.10.2 (2017-05-16)
Dates are converted to numbers by default (set cellDates:true to emit Dates)
Module does not export CFB
0.9.10 (2017-04-08)
--perf renamed to --read-only
0.9.9 (2017-04-03)
default output format changed to XLSB
comment text line endings are now normalized
errors thrown on write when worksheets have invalid names
0.9.7 (2017-03-28)
XLS legacy !range field removed
Hyperlink tooltip is stored in the Tooltip field
0.9.6 (2017-03-25)
sheet_to_json now passes null values when raw is set to true
sheet_to_json treats null stub cells as values in conjunction with raw
0.9.5 (2017-03-22)
cellDates affects parsing in non-XLSX formats
0.9.3 (2017-03-15)
XLML property names are more closely mapped to the XLSX equivalent
Stub cells are now cell type z
0.9.2 (2017-03-13)
Removed stale TypeScript definition files. Flowtype comments are used in the
xlsx.flow.js source and stripped to produce xlsx.js.
sed usage reworked to support GNU sed in-place form. BSD sed seems to work,
but the build script has not been tested on other sed variants:
$ sed -i.ext [...]# GNU
$ sed -i .ext [...]# bsd
0.9.0 (2017-03-09)
Removed ods.js source. The xlsx.js source absorbed the ODS logic and exposes
the ODS variable, so projects should remove references to ods.js