SheetJS
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
SheetJS
807eac273b
miscellany
...
- systemjs browser example
- more precise file type resolution
- small corner cases from test corpus
- removed neq in tests (fixes #735 h/t @TeamworkGuy2)
- package.json devDependencies versions (fixes #740 h/t @the-spyke)
2017-07-26 04:35:28 -04:00
Danwakeem
d28cc872c7
XLS/XLSX/XLSB Row Outline Levels ( closes #723 )
...
note: @sheetjsdev rewrote implementation, original PR author used
2017-07-10 06:02:06 -04:00
SheetJS
aff7b95272
Date/Time Minutiae
...
- TZ consistency for DBF and others (closes #663 h/t @peeyushsrivastava)
- Date1904 XLSX/XLSB/XLS/XLML consistency (fixes #175 h/t @SheetJSDev)
- dateNF corrects for plaintext date parsing (fixes #658 h/t @mmancosu)
- new travis tests override local time zones
2017-06-01 17:22:11 -04:00
SheetJS
3ff724e349
version bump 0.10.2: date processing corner cases
...
- all formats follow cellDates / dateNF (fixes #653 h/t @mmancosu)
- IE6-8 Date corrections
- XLML Date force UTC
- updated SSF to 0.9.3 (fixes #372 h/t @HuFlungDu)
- removed CFB export
2017-05-17 00:23:36 -04:00
SheetJS
99b513875b
lint and type fixes
...
- removed CFB test (fixes #654 h/t @wolfgang42)
- book_append_sheet optional name (fixes #652 h/t @jomel)
- strict mode compliance (h/t @simon-p-r @loongdefect @appersonj)
- flow fixes (h/t @jameskraus for help with Date#getYear)
- fixed minifier to generate ExtendScript-compatible code
2017-05-13 14:21:22 -04:00
SheetJS
c3c0bc5266
version bump 0.10.1: json_to_sheet, misc fmts
...
- SYLK auto fail into DSV on bad header (fixes #651 h/t @mmancosu)
- CSV automatically wrap `ID` in quotes
- json_to_sheet (see issue #610 )
2017-05-11 14:36:32 -04:00
SheetJS
7b4bafba49
Miscellaneous format fixes
...
- SSF update to address extendscript issue (fixes #608 h/t @mjdb3d)
- XLSX cellDates set date format (fixes #647 h/t @psalmody)
- ODS add stub stylesheet for Excel (fixes #649 h/t @WaqasJaved1)
- CSV with UTF8 BOM (fixes #650 h/t @charlesread)
- DIF/CSV fuzzy date speculation
- SYLK parse RC formulae
- CSF utils for manipulating workbooks
2017-05-11 03:29:59 -04:00
SheetJS
a8736580a5
version bump 0.10.0: cleanup
...
- updated SSF to 0.9.2
- XLSB style records and number format writing
- CSV avoid parseFloat (fixes #646 h/t @jabbermarky)
- CSV recognize mac line ending (fixes #648 h/t @charlesread)
- BIFF2 format table refactored to align with SSF
- BIFF5 image data exposure
- SSF custom format auto table update (fixes #267 h/t @Fangmingdu)
- eslint more checks
- browser test timeout extended to 10 seconds
2017-05-09 14:07:57 -04:00
SheetJS
810c447bf9
browser tests and doc cleanup [ci skip]
2017-05-01 01:00:00 -04:00
SheetJS
b9bc0a1627
version bump 0.9.13: string formatting
...
- dateNF parse option controls interpretation of code 14
- SSF updated to 0.9.1
- SYLK write formulae
- DIF support Excel-style data storage
- ODS/FODS automatic styles for date formatting
Issues:
- Fixes #181 h/t @CharlesNo
- Fixes #200 h/t @JohnJeong123
- Fixes #208 h/t @jerryhe88
- Fixes #262 h/t @JohnJeong123
- Fixes #269 h/t @calebeaires
- Fixes #326 h/t @railty
- Fixes #392 h/t @FourLeafClover
- Fixes #449 h/t @dougschiller
- Fixes #560 h/t @dpackage
2017-04-30 12:27:03 -04:00
SheetJS
dcee744e4e
row and column size and visibility
...
- XLSX/XLSB/XLS/XLML/SYLK rows and columns
- corrected pixel/point calculations using PPI
- XLSX/XLSB generate sheet view
- clarified sheet protection default behavior
- fixed eslintrc semi check
2017-04-28 03:40:40 -04:00
Patrick Lehmhecker
c6f96c3df7
converting to json with a selected range and header: 1 now lets the array start at zero
2017-04-26 17:32:42 +02:00
SheetJS
95a377c0e4
more format parity
...
- XLS/XLSX/XLSB/XML/ODS cellFormula option + test
- XLS/XLSX/XLSB/XML/ODS cellText option + test
- XML document property order
- XML write margins + protection
- removed gitbook search
2017-04-25 22:27:12 -04:00
reviewher
83ec60688f
Windows build ( fixes #589 h/t @simon-p-r)
...
run `make help` for more info
2017-04-24 06:39:00 -04:00
SheetJS
6853c99ce5
rich text HTML + preview
2017-04-19 23:43:43 -04:00
Siguza
c356e91fdc
XLSX write page margins
...
changes distilled from Siguza/js-xlsx
see https://github.com/protobi/js-xlsx/pull/19 for discussion
2017-04-16 22:31:33 -04:00
SheetJS
1d61054602
HTML Write support
...
- 'html' bookType write format
- basic HTML entity encoding (fixes #629 h/t @xkr47)
- HTML string and table merge cell fixes
- doc notes on nodejs streaming
2017-04-16 00:32:13 -04:00
Jonas Berlin
616d2e534f
XLSX Proper HTML entity escaping for .h
2017-04-13 14:33:00 -04:00
Jani Hartikainen
c9d0aa140d
Small Test and Doc Fixes
2017-04-13 03:10:18 -04:00
SheetJS
1587688aea
Page Margins
...
- XLSB read/write page margins
- XLSX/XLS/XLML read page margins
- separated encrypted XLSX/XLSB document logic from XLS
2017-04-12 21:29:38 -04:00
SheetJS
0189bc23ca
Defined Names
...
- XLSX read/write defined names
- XLSB/XLS/XLML read defined names
Issues:
- fixes #83 h/t @developergdd
- fixes #6 , fixes #599
2017-04-11 18:15:36 -04:00
SheetJS
5187bc0b63
Basic AutoFilter Read/Write
...
- XLSX/XLSB read/write autofilter
- XLS/XLML/*ODS read autofilter
- Workbook Properties override via Props option
- XLSB write sheet protection
Issues:
- fixes #472 h/t @nishthasb
- fixes #478 h/t @yonatannn
- see #623 h/t @jcarvin
2017-04-10 01:11:32 -04:00
SheetJS
f43cacaf5e
experimental dense representation
...
- browser demo save file in global (fixes #573 h/t @WildDusk)
- flesh out XLSB record expectations (fixes #624 h/t @pgeeh)
- `dense` mode (fixes #34 h/t @schleumer)
2017-04-08 02:55:35 -04:00
SheetJS
b9dae134f2
TXT/PRN
...
- UTF-16 Unicode Text (TXT) write
- Lotus Formatted Text (PRN) read/write
- DBF version 2 field length adjustments
- throw errors if SheetNames is invalid (fixes #376 h/t @pietersv)
2017-04-02 20:16:03 -04:00
SheetJS
3a310bd3a7
Read/Write Comments
...
- XLSB/XLSX/XLML write comments
- BIFF2 write date cells (see #586 h/t @roccomuso)
- ODS read cell comments (fixed #315 h/t @yisk)
- XLSX / XLSB emit empty comments when necessary
- changed node detection logic (fixes #614 h/t @mhenris)
- fixes #605 h/t @ylbweb
- fixes #233 h/t @hanxi @osecki
- fixes #192 h/t @abarik1981 @stla
- fixes #183 h/t @aravindkoneru @ryangallen
2017-04-02 02:47:25 -04:00
SheetJS
b93569badf
more formats from js-harb
...
- clarify usage of Props and Custprops (fixes #274 h/t @michahell)
- SYLK from js-harb
- DIF from js-harb
- HTML empty string bug fix
2017-04-01 03:32:12 -04:00
SheetJS
97f7c1d4bf
sheet visibility
...
- XLSB read V H VH + write V H VH
- XLSX read V H VH + write V H VH
- XLML read V H VH + write V H VH
- XLS read V H VH
- fixes #123 h/t @rla-dev @Mior
- fixes #464 h/t @enobufs @thowk
- fixes #498 h/t @digity
- fixes #503 h/t @digity
2017-03-31 14:46:42 -04:00
SheetJS
4743085cb5
XLSB/XLSM sheet rels and hyperlinks
...
- XLSB/XLSM workbook/worksheet code names for VBA
- XLSX/XLSB write hyperlinks
- updated CFB to 0.11.1
Fixes:
- fixes #615 h/t @johnothetree (XLSM CodeName)
- fixes #93 h/t @SheetJSDev (Write Hyperlinks)
- fixes #156 h/t @MayaGi (XLSX Write Hyperlinks)
- fixes #344 h/t @slonoed (XLSX Write Hyperlinks)
2017-03-30 20:47:35 -04:00
SheetJS
b89a876076
version bump 0.9.7: write features
...
- write !cols widths : XLSX XLSB XLML
- write hyperlinks : XLML
- XLSB convert date cell to numeric on write
- fixed issue with assigning self in jszip
issues:
- closes #607 h/t @jscheid
- closes #195 h/t @asfman
2017-03-28 18:03:03 -04:00
SheetJS
663270b762
XLS/XLSX/XLSB Interpret Chartsheets as Data Tables
...
- chartsheets are now stored as sheets with "!type" set to "chart"
- fixed Strict XML Workbook Relationships
- stubbed support for dialog and macro sheets
- removed legacy XLS `!range` field
2017-03-27 17:41:14 -04:00
SheetJS
70c48a74b9
API Improvements
...
- `aoa_to_sheet` function (fixes #314 h/t @fonzy2013 @rvdwijngaard)
- `writeFileAsync` function (fixes #396 h/t @barbalex)
- `sheet_to_json` tests + docs + blankrows (fixes #602 h/t @EEaglehouse)
- write number format scan now includes every index >= 50
- propagate SSF IE8 fixes (fixes #171 h/t @sheetjsdev)
- update shim for extendscript (see #603 h/t @firas3d)
- more flow type definitions
2017-03-24 21:36:40 -04:00
Jim
9ae3a64af8
`sheet_to_json` default value
...
uses `defval` key in options object
fixes #583 h/t @jimjin
fixes #582 h/t @jimjin
fixes #147 h/t @jtadmor
2017-03-23 01:58:08 -04:00
SheetJS
69782ca211
version bump 0.9.5: IE8+ browser tests
...
- minor changes to work around IE incompatibilities
- updated shim and browser tests
2017-03-22 21:18:40 -04:00
LieJiang
d83986d31c
SSF undefined string guard ( fixes #584 )
...
note: @sheetjsdev authored commit, original PR date/author used
2017-03-22 11:23:13 -04:00
SheetJS
a846f7184d
utility improvements
...
- sheet_to_csv strip option (fixes #182 h/t @davidworkman9)
- sheet_to_json dateNF option (fixes #134 h/t @rotemtam)
- file type detection expanded to 4 byte magic number
2017-03-22 03:50:11 -04:00
SheetJS
c7010eec35
XLS/XLSX/XLSB/XLML cellDates support
...
- uniform number->date cell conversion
- update SSF to 0.9.0 (for is_date)
- namespaced rich str xml
- license file changed to appease GH automatic license detector
| id | author | comment |
|:------------|:-------------|:----------------------------------------|
| closes #581 | @Aymkdn | XLSX cellDates + SSF.is_date |
| closes #126 | @elad | same as #581 h/t @SystemParadox |
| closes #59 | @vratiu | same as #581 |
| closes #279 | @varunoberoi | raw json output uses date |
2017-03-21 16:44:35 -04:00
SheetJS
245dd7fd82
Documentation improvements
...
- multiformat column widths (fixes #591 h/t @sheeeeep)
- skip nested BIFF files
2017-03-20 05:02:25 -04:00
Pieter Sheth-Voss
f90fbd32e5
Parse XLSX Styles
...
some changes picked from #263
2017-03-19 02:50:30 -04:00
SheetJS
7888070603
explicitly share styles and themes
2017-03-18 19:25:50 -04:00
SheetJS
5a3774e36e
Formula write support
...
- XLSX/XLML/ODS/CSV formula write
- XLS Array/Formula record parsing
- ODS to/from CSF formula conversion
- XLML parse negative dates
- formula multiformat and roundtrip tests
- update SSF
Closes issues:
- closes #549 h/t @omershelef
- closes #306 h/t @akaustel
- closes #300 h/t @wawanopoulos
- closes #152 h/t @florf
- closes #103 h/t @christocracy
- closes #112 h/t @johnyesberg
- closes #307 h/t @alexanderknapstein
2017-03-17 20:45:06 -04:00
SheetJS
ea1873e572
version bump 0.9.3: multiformat alignment
...
- merge cells and stubs consistency
- character entity decoding
- cellDates processing for other formats
2017-03-15 21:17:24 -04:00
SheetJS
d3eaa62d45
unify stub cells with type `z`
...
- fixes #382 h/t @jugaltheshah @pimpelsang
- fixes #333 h/t @xushuheng0623 @abhishek1234321 @mateuszkrzeszowiec
- fixes #79 h/t @volodymyrl @elad
2017-03-15 04:19:02 -04:00
MURAKAMI Masahiko
05185e13f2
Fixed `vbaraw` parsing
...
- fixes #594 h/t @fossamagna
- fixes #348 h/t @aleramesh
2017-03-14 14:40:29 -04:00
SheetJS
88eb98587c
reduced build output on travis
2017-03-14 13:24:40 -04:00
SheetJS
7cb978b846
XLML write support
...
- XLML write (fixes #173 h/t @SheetJSDev)
- removed old iteration style from README (see #592 )
- CellXF & StyleXF fields (fixes #414 h/t @ronnywang)
2017-03-14 04:19:51 -04:00
SheetJS
71c23d9e2a
version bump 0.9.1: cpexcel update
...
- codepage upgraded to 1.7.0
- remove require dark pattern (closes #554 h/t @keyiis)
- test for JSON header disambiguation
- utility functions documentation (fixes #424 h/t @dskrvk)
2017-03-10 18:39:17 -05:00
SheetJS
4880e9219f
more formula parsing logic
...
- added more function argc counts and cleaned up error rendering
- disabled XLS error on MTRSettings (fixes #466 h/t @dskrvk)
- handle more unexpected XML empty tags (fixes #510 h/t @rahulsindc)
- throw error if SheetNames is not unique (fixes #231 h/t @zippy1981)
2017-03-10 03:39:51 -05:00
SheetJS
54b528eaed
version bump 0.9.0: merged ODS into XLSX
...
The optional ODS module has been completely merged into xlsx.js and the
corresponding scripts have been removed. The new xlsx.js file provides
appropriate ODS exports, so fixing is a matter of removing ods.js refs.
2017-03-09 20:09:18 -05:00
SheetJS
7b6fb7b327
version bump 0.8.8: HTML
...
- read MSO HTML (fixes #419 h/t @vineetl fixes #458 h/t @tienne)
- roll out xml namespace fix (closes #362 h/t @PierreOCXP)
- cellDates clarifications
2017-03-09 00:24:32 -05:00