Skip to content

Read + write style information to .xlsx #263

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
protobi wants to merge 104 commits into
base: master
Choose a base branch
from
Open

Read + write style information to .xlsx #263

Changes from 2 commits
Commits
Show all changes
104 commits
Select commit Hold shift + click to select a range
0227496
Add ability to save cell styles to .xlsx
protobi-pieter Feb 28, 2015
845d2a8
Added support for alignment
protobi-pieter Feb 28, 2015
a562150
Use jQuery parseXML to preserve case in XML
protobi-pieter Mar 1, 2015
5f7a0f2
Removed dependence on cheerio, jquery; added xmlbuilder;
protobi-pieter Mar 2, 2015
cd2b20f
Remove stray logs
protobi-pieter Mar 2, 2015
576b59f
Fix issue with custom formats
protobi-pieter Mar 2, 2015
05b58d8
Escape embedded quotes
protobi-pieter Mar 3, 2015
1f02e5b
Handle embedded quotes in number formats
protobi-pieter Mar 5, 2015
91ec052
Added support for borders
protobi-pieter Mar 7, 2015
5e44331
Remove stray console.log() calls
protobi-pieter Mar 7, 2015
c3af249
Add styles to README.md
protobi-pieter Mar 9, 2015
97d4001
Update Style specifications in README.md
protobi-pieter Mar 9, 2015
33dc7b8
Update README.md
protobi-pieter Mar 9, 2015
aa8f3a7
Add support for textRotation
protobi-pieter Mar 12, 2015
9b76f6b
Update README for textRotation
protobi-pieter Mar 12, 2015
1a51c40
Remove broken link
Mar 12, 2015
0e2b8a4
Merge pull request #1 from knownasilya/patch-2
Mar 12, 2015
ad2a120
Update README.md
Mar 13, 2015
4f4f7fc
Fix issue exporting font color
protobi-pieter Mar 20, 2015
33c32f0
Merge remote-tracking branch 'origin/master'
protobi-pieter Mar 20, 2015
27a300b
Read styles - font, fill and numFmt
protobi-pieter Mar 28, 2015
37a031c
Parse font bold-italic-strike-outline-shadow-superscript-subscript
protobi-pieter Mar 28, 2015
995f5e8
Parse font bold-italic-strike-outline-shadow-superscript-subscript
protobi-pieter Mar 28, 2015
8da3738
Update README.md
protobi-pieter Mar 28, 2015
9102c82
Added round-trip test for styles
protobi-pieter Mar 29, 2015
114f257
Merge remote-tracking branch 'origin/master'
protobi-pieter Apr 15, 2015
5f9576a
Read borders and alignments
protobi-pieter Apr 15, 2015
0b1a040
Merge changes from upsteam
protobi-pieter Apr 15, 2015
08e648b
Update tests to reflect change in spec for fills
protobi-pieter Apr 16, 2015
51b7cab
Parse raw_rgb
protobi-pieter Apr 17, 2015
89066b4
Save fill color to .rgb but not tint
protobi-pieter Apr 17, 2015
5dbf215
Correct hex2RGB coding, apply tints
protobi-pieter Apr 17, 2015
c287383
Add syntax highlighting to readme examples
Apr 20, 2015
acf60c2
Merge pull request #2 from knownasilya/patch-2
Apr 20, 2015
40cfb0c
Document wrapText
protobi-pieter May 8, 2015
21e1976
Merge branch 'master' of https://github.com/protobi/js-xlsx
protobi-pieter May 8, 2015
858abf1
Remove requirement that require, module or jquery be defined before u…
protobi-pieter May 12, 2015
ed0cd9b
Add alignment; update README
protobi-pieter May 21, 2015
4099a24
Default gray125 style per pull request #3
protobi-pieter Jun 4, 2015
0255a05
Remove temp example files from repo
protobi-pieter Jun 12, 2015
8801e76
Make dist and update package name
protobi-pieter Jun 13, 2015
0096c09
Update README, bower, package
protobi-pieter Jun 13, 2015
9145958
Update README, bower, package
protobi-pieter Jun 13, 2015
a602355
Update README, bower, package
protobi-pieter Jun 13, 2015
d60a0a5
Update README, bower, package
protobi-pieter Jun 13, 2015
3010d93
Update README, bower, package
protobi-pieter Jun 13, 2015
c034eda
Update README, bower, package
protobi-pieter Jun 13, 2015
1ca3c3e
Remove lab, .idea, test-csv, test-acid, etc. from repo
protobi-pieter Jun 26, 2015
e7b06d7
Remove lab, .idea, test-csv, test-acid, etc. from repo
protobi-pieter Jun 26, 2015
f52c80e
Remove lab, .idea, test-csv, test-acid, etc. from repo
protobi-pieter Jun 26, 2015
dcf6f17
Retain styles for blank cells
protobi-pieter Aug 11, 2015
0d1281c
Added test files
protobi-pieter Aug 11, 2015
d76234a
Merge remote-tracking branch 'origin/master' into beta
protobi-pieter Aug 11, 2015
3e3633a
Merge master to preserve blank style; increment version number
protobi-pieter Aug 11, 2015
348c533
Update bower version to 0.8.5
protobi-pieter Aug 11, 2015
57b6fd4
Pull changes to persist styles with blank cells; increment versions f…
protobi-pieter Aug 11, 2015
7461389
Adds cheerio dependencie for tests/test-style.js
godu Aug 13, 2015
905c512
Adds tests
godu Aug 13, 2015
599f285
Breaks ref in style object
godu Aug 13, 2015
d00f36f
Merge pull request #10 from CoorpAcademy/fix-ref-styles
protobi-pieter Aug 13, 2015
03b755b
Add showGridlines
protobi-pieter Dec 4, 2015
fd83f20
Merge branch 'master' of https://github.com/protobi/js-xlsx into beta
protobi-pieter Dec 4, 2015
8b1add6
Add showGridLines as option
protobi-pieter Dec 4, 2015
2886195
Merge branch 'master' of https://github.com/protobi/js-xlsx
protobi-pieter Dec 4, 2015
634699f
Merge branch 'master' of https://github.com/protobi/js-xlsx into beta
protobi-pieter Dec 4, 2015
d4e0b8b
Bump bower version to 0.87
protobi-pieter Dec 4, 2015
43f5698
Add row and column breaks
protobi-pieter Dec 5, 2015
bbeec3e
Add row/col breaks
protobi-pieter Dec 5, 2015
376096b
Add page setup
protobi-pieter Dec 5, 2015
0bf1153
Add page scale and orientation
protobi-pieter Dec 5, 2015
7de41c2
Add doc props
protobi-pieter Dec 5, 2015
f984bd6
Add rowBreaks, colBreaks, scale, showGridLines
protobi-pieter Dec 5, 2015
fe748ad
Copy README from beta
protobi-pieter Mar 8, 2016
166d0e3
Update README.md
protobi-pieter Mar 8, 2016
9407fe8
Update README.md
protobi-pieter Mar 8, 2016
aceebf4
Update README.md
protobi-pieter Mar 8, 2016
0e62411
Update README.md
protobi-pieter Mar 8, 2016
050b74e
Update README.md
protobi-pieter Mar 8, 2016
2ec18e9
Update README.md
protobi-pieter Mar 8, 2016
bed6327
Set tabSelected to 0 per issue #26
protobi-pieter Apr 6, 2016
876c4a0
Set tabSelected to 0 per issue #26
protobi-pieter Apr 6, 2016
eef7da3
Merge branch 'master' of https://github.com/protobi/js-xlsx
protobi-pieter Apr 6, 2016
0b8e538
Add repeating print headers
protobi-pieter May 24, 2016
2424890
Merge remote-tracking branch 'origin/beta' into beta
protobi-pieter May 24, 2016
8198744
merge from beta
protobi-pieter May 25, 2016
245ffb8
Update tests; add feature to freeze headerrow
protobi-pieter May 25, 2016
34d618c
Update tests; add feature to freeze headerrow
protobi-pieter May 25, 2016
3c7f807
Revert package name
protobi-pieter May 25, 2016
796fbb5
Fix file getter: letter case not match
chikh Jul 14, 2016
d3f6343
Apply letter case issue fix to the source code
chikh Sep 10, 2016
d5092b4
Merge pull request #46 from noodoo/fix/lower-case-files
protobi-pieter Sep 29, 2016
6e66789
PR #40 - Skip cells with incorrect link to shared strings
protobi-pieter Oct 11, 2016
1903cff
Merge remote-tracking branch 'origin/master'
protobi-pieter Oct 11, 2016
9edf279
Add freeze pane option
protobi-pieter Apr 3, 2017
f959b02
Add freeze panes
protobi-pieter Apr 3, 2017
a03dc21
Add freeze panes
protobi-pieter Apr 3, 2017
c224819
Fixed Style Table in README.md
zeg-io Apr 4, 2017
68ba4e8
Merge pull request #64 from zeg-io/patch-1
Apr 4, 2017
f2520b7
Freeze columns
protobi-pieter May 31, 2017
c86472d
Merge branch 'master' of https://github.com/protobi/js-xlsx
protobi-pieter May 31, 2017
9233322
Add examples
protobi-pieter Apr 1, 2019
6226e1a
Undo last commit
protobi-pieter Sep 18, 2019
6d0f51f
Fixed horizontal alignment values
oosswwaalldd Aug 27, 2020
8f7a294
Merge pull request #151 from oosswwaalldd/patch-1
protobi-pieter Aug 28, 2020
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
2 changes: 1 addition & 1 deletion README.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -562,7 +562,7 @@ top-level attributes: `fill`, `font`, `numFmt`, `alignment`, and `border`.
| | | `"0.00%;\\(0.00%\\);\\-;@"` // string specifying a custom format, escaping special characters
| | | `"m/dd/yy"` // string a date format using Excel's format notation
| alignment | vertical | `"bottom"` or `"center"` or `"top"`
| | horizontal | `"bottom"` or `"center"` or `"top"`
| | horizontal | `"left"` or `"center"` or `"right"`
| | wrapText | `true ` or ` false`
| | readingOrder | `2` // for right-to-left
| | textRotation | Number from `0` to `180` or `255` (default is `0`)
Expand Down