5a36cb423d
NaN and Infinity error export
...
- `read` handle `Int8Array` (to support Java engines)
- `sheet_to_formulae` option to suppress values
- handle unexpected `<charset/>` (fixes #3143 h/t @dearzubi )
2024-07-04 15:54:34 -04:00
5ef49e2b96
XLML Streaming Write
...
- CSV Export only quote leading ID (fixes #2959 )
2024-05-31 03:16:53 -04:00
a0bed2a97d
version bump 0.20.2
...
see https://regexide.com for more details
2024-04-04 21:30:28 -04:00
e4a66516e4
remove flow array comment workarounds
...
- XLSB use #REF! for unsupported defined name ref (fixes #3059 h/t @NenadC2 )
2024-02-02 01:52:14 -05:00
d4d4ff3da2
SYLK error cells read/write ( fixes #3049 )
2024-01-10 04:54:10 -05:00
955543147d
version bump 0.20.0
2023-06-23 05:48:47 -04:00
6e260c9185
cell comments
...
- `sheet_to_json` handle arrays (h/t AaronWoodrow)
- XLS parse comment visibility (h/t Godrules500)
- chrome manifest v3 writeFile support
- raw v8 (no TextEncoder/TextDecoder) optimization
- handle empty shared formula body (h/t florian)
2023-06-13 00:49:18 -04:00
050f66ce1b
version bump 0.19.0
2022-10-23 21:05:59 -04:00
ad1ce0d9b0
parsers expose original book type
2022-07-08 18:45:00 -04:00
4cc0412154
roundtrip 1904 date setting
2022-06-06 19:10:33 -04:00
83ddb4c120
unified autofilter defined name sync on export
2022-05-30 04:42:10 -04:00
e6ae86df55
XLSB/ODS write defined names
2022-05-24 21:45:55 -04:00
reviewher
e0fc89246a
Fix bad google sheets format 'd.m'
2022-04-05 19:14:12 -07:00
0f0b3de821
popping IIFEs to appease rollup tree shaking
2022-03-22 16:19:05 -04:00
69bb1e79a3
"side-effect free"
2022-03-19 21:54:41 -04:00
reviewher
90a7b4ee91
remove SSF._general_int
2022-03-16 21:38:06 -07:00
61b17a8bc8
version bump 0.18.4
2022-03-15 23:23:39 -04:00
0044f3be82
clean cptable global pollution
2022-03-11 01:16:24 -05:00
c6a86cfe98
make stream utils available to Node ESM
...
- sheet_to_csv blankrows/strip (fixes #2274 h/t @dmongit)
- sheet_to_json fix dedupe (see #2460 h/t @giuliohome)
- mini build browser tests
2022-03-08 20:44:10 -05:00
fbdd43a3f4
deno and node ESM tests
2022-02-13 04:49:30 -05:00
Zaheer Ud Din
10ae7c9fec
Strip quoted delims in file type magic 0x3C
2021-12-05 10:19:25 +05:00
29e3bb4c1f
Lotus WK1 worksheet writer [ci skip]
...
- unpack errors from WK3 long double
- explicitly ignore ss:Null in XLML (fixes #2447 )
2021-11-08 00:01:12 -05:00
e59de73f99
Hyperlink cleanup [ci skip]
...
- XLS normalize URLs and use moniker (fixes #2385 )
- ODS row heights and column widths (fixes #2378 )
- DSV parse of files with leading <, deviating from Excel (fixes #1238 )
- read `ArrayBuffer` with no type (fixes #2316 )
- removed invalid test files that throw errors due to string length
- AOA/JSON null optional map to #NULL! (fixes #1196 )
2021-09-30 03:28:03 -04:00
a4ee0ef05a
outline minutiae
...
- column levels (fixes #1655 )
- XLSX parse sheetPr with children (fixes #1798 )
- XLSX enforce 32768 string limit (fixes #1537 )
2021-09-22 02:45:08 -04:00
82b7ada6c7
version bump 0.16.7
...
- set active worksheet to first visible (fixes #1433 h/t @ManjunathSVBB)
2020-09-11 04:38:33 -04:00
257d4e6db2
version bump 0.16.0
...
closes #1904 h/t
- @atcazzual : Adam Cazzolla of the Sonatype Security Research team
- @davisjam : James (Jamie) Davis of Virginia Tech
2020-04-19 21:17:44 -04:00
3468395494
x-spreadsheet demo
2020-03-22 21:57:53 -04:00
c91d2187e6
XLML case insensitive ( fixes #1800 )
...
h/t @panraj01, many tags are case insensitive
2020-03-18 02:47:02 -04:00
0a57229d3b
version bump 0.15.6: niggles from 2012
...
- CFB prevent infinite loop (h/t @rossj)
- pass updated eslint checks (fixes #1726 h/t @BjoernRave)
- defined name proper encoding (fixes #1785 h/t @laohe98)
- correct theme color order (fixes #389 h/t @foreverpw)
- ODS / XLML more aggressive flagging of stub cells
- cellStyles implies sheetStubs
- updated SSF to 0.10.3
2020-03-15 03:57:44 -04:00
b7c0b0d914
fixed flow typecheck
...
- update FilterDatabase defined name when writing AutoFilter
- XLML stub cells have blank Data block
- HTML export honor `id` option
- expose `sheet_get_cell`
2019-10-31 23:09:14 -04:00
4aeb0a786a
version bump 0.15.0: mini build
...
- new xlsx.mini build that strips XLS/XLSB/niche formats
- updated CFB to 1.1.3
- removed niche sheet_to_{dif,slk,eth} utilities
- removed exported ODS parse/write funcs, read/write still supports ODS
2019-08-04 16:12:56 -04:00
eca6b457be
version bump 0.13.5: HTML newlines
...
- HTML Export emits `<br/>` (fixes #1239 h/t @keithbox)
- Unicode Defined Name ODS
2018-08-25 19:44:35 -04:00
93f7749bec
version bump 0.12.8: sheetRows multiformat support
...
- all formats accept `sheetRows` option (fixes #1062 h/t @prog666)
- `table_to_*` support for `sheetRows`
- demo cleanup
2018-04-06 02:39:48 -04:00
5de62a947f
version bump 0.12.5: ancillary utility update
...
- add BOM to `stream.to_csv` (fixes #1024 h/t @hr5959)
- `utils.format_cell` type (h/t @victorj2307)
- duktape niggles
- demo cleanup
2018-03-12 22:51:54 -04:00
7149728c7c
version bump 0.12.4: zip cleanup
...
- PK magic number bound (fixes #1013 h/t @wlpeter)
- removed JSZip conflict (fixes #1017 h/t @seanmars)
- updated CFB to 1.0.5
- demo HTML conversion `string`
2018-03-05 19:34:04 -05:00
8508ad4e94
version bump 0.12.2: BIFF2-4 features
...
- correct BIFF-dependent cell reference wrapping
- record layout fixes from sample files
- use BIFF version 2.4.338 for BOF (fixes #995 h/t @benjaminleetmaa)
- fixed potentially vulnerable regexes (h/t @davisjam)
- removed insecure deep dependency (fixes #996 h/t @dcatoday)
2018-02-21 02:10:33 -05:00
f002afae4b
version bump 0.12.0: extendscript fixes
...
- ExtendScript write quirks (fixes #986 h/t @grefel)
- BIFF8 write number formats (fixes #987 h/t @scwood)
- xlsx.extendscript.js library script
- readFile / writeFile support ExtendScript
- flow update
2018-02-08 13:21:39 -05:00
75845a0ca7
version bump 0.11.19: browser writeFile
...
- IE6-9 ActiveX + VBScript shim
- `writeFile` supported in browser
- `oldie` demo for IE write strategies
2018-02-03 15:46:32 -05:00
c2ec7555fb
version bump 0.11.18: infrastructure
...
- updated dependencies
- fixed eslint config
- fusebox demo
2018-01-23 04:07:55 -05:00
c654a2656b
archaic browser compatibility and testing
...
IE11 Compatibility View levels 5 and 7 (see #952 )
Firefox 5.0+ passes browser test (see #950 )
2018-01-11 03:07:07 -05:00
1d74977718
version bump 0.11.17: sheet_add_{aoa,json}
...
- Skip extraneous trailing records (fixes #938 h/t @benjaminleetmaa)
- XLS -> XLML oddities (fixes #678 h/t @buserror)
- ionic demo
- sheet_add_aoa and sheet_add_json
Issues:
- fixes #947 h/t @fpasxos
- fixes #666 h/t @samuelkavin
- fixes #301 h/t @acgentry
- fixes #561 h/t @Ideandro
2018-01-09 02:36:02 -05:00
f277ebe140
version bump 0.11.16: refresh
...
- HTML whitespace (fixes #849 h/t @laurentauthier)
- XLML number format write (fixes #904 h/t @james-boswell)
- XLAM/XLA write
- 'array' write type
- XLSX/XLSB/XLS/XLML RTL read/write
- XLS merge cells write
- demo and typing refresh
2017-12-30 03:20:00 -05:00
b3873ea615
version bump 0.11.14: links
...
- BIFF5 + ODS read named ranges
- internal link range normalization
- BIFF8 + ODS link write
- internal link write (fixes #685 h/t @gawi)
2017-12-14 20:18:40 -05:00
7c7f4a69d4
version bump 0.11.9
...
- CLI `--book` convert all worksheets (fixes #701 h/t @pmelisko)
- Detect ";"-DSV with no "\t" or "," (fixes #875 h/t @sh977218)
- editable HTML uses spans for IE6+ compat (fixes #851 h/t @elogicmedia)
- XLSB formula structure parallels XLS (fixes #680 h/t @bstiel)
2017-11-15 13:14:02 -05:00
f968dfe4ed
version bump 0.11.6: ancillary format update
...
- BIFF5 XLS write (bookType "biff5")
- DBF Level 7 read
- ODS whitespace and repeated rows
- flow and lint cleanup
2017-10-16 20:14:32 -04:00
Ravelle Kelley
ef9f3f9ca5
fix worksheet protection options
2017-10-16 18:19:53 -04:00
af3df44633
version bump 0.11.5: "string" type
...
- proper JS string input / output type
- bower main now uses full version (fixes #820 h/t @newmesiss)
- DOM parse directly acts on innerHTML (see #779 h/t @danxfisher)
- unicode core props and ext props (fixes #822 h/t @fureweb-com)
- shim update for IE10/11
- test refresh and flow checks
2017-09-30 02:18:11 -04:00
635310b639
version bump 0.11.3: "array" type
...
- phased out Array map invocations (fixes #620 h/t @dullin)
- "array" type supports Uint8Array
- Headless browser examples
- blank cells are omitted or stubbed (fixes #779 h/t @domxa)
- removed transferrables from demo
2017-08-19 19:06:34 -04:00
935821423f
version bump 0.11.1: dist cleanup
...
- dist scripts properly export library
- XLS/XLSB formulae quote sheet names containing spaces
- skipHidden ported to streaming CSV write
- updated codepage to 1.11.0
- flow and TS updates
- webpack demo example using dist scripts
- requirejs demo
2017-08-05 02:32:57 -04:00
6732eb76f8
hodgepodge of fixes
...
- missing formula elements rewritten to valid defined names (see #680 )
- comment author length limit enforced
- XLS ifmt references renamed to numFmtId for consistency with XLSB
- removed circular symlink
- mangle/compress with uglify
- more flow comments
2017-07-27 17:15:55 -04:00
