
File name
Commit message
Commit date
2023-05-06
2023-04-18
File name
Commit message
Commit date
File name
Commit message
Commit date
CHANGELOG#
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.5#
- Enabled
sideEffects: false
in package.json - Basic NUMBERS write support
v0.18.4#
- CSV output omits trailing record separator
- Properly terminate NodeJS Streams
- DBF preserve column types on import and use when applicable on export
v0.18.3#
- Removed references to
require
andprocess
in browser builds
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
andget_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
anddecode_cell
do not rely onencode_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 impliessheetStubs
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 functionsheet_to_json
explicitly supportnull
as alias for default behaviorencode_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 crashesstream.to_json
doesn't end up accidentally scanning to max row
0.14.0 (2018-09-06)#
sheet_to_json
default flipped toraw: 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 toJSZipSync
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 passesnull
values whenraw
is set totrue
sheet_to_json
treatsnull
stub cells as values in conjunction withraw
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 producexlsx.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