[ANN] Write Excel files with XLSX.jl v0.2.0

Community
,
21

Here’s a snippet that may help:

julia> using Colors

julia> somecolor = colorant"coral"
RGB{N0f8}(1.0, 0.498, 0.314)

julia> hex(somecolor, :AARRGGBB)
"FFFF7F50"
2 Likes
22

Would it make sense to use GitHub - KristofferC/Crayons.jl: Colored and styled strings for terminals. for the formatting ? May be a bit overkill ?

23

Actually, and as I’m sure @tecosaur knew when I was a little hesitant before, it is trivially easy to add support for all the named colors is Colors.jl.

24

This is very exciting. Is there documentation how to install this fork to help test?

25

You can download the package as a zip file from github and unzip to a local folder. Then do something like

using Pkg
Pkg.develop(path="pathToXLSX.jl")
using XLSX

(I think that’ll work).

Note: This link is to a slightly updated branch than the one I linked to before.

26

You can add branches directly from Pkg like

(jl_9UWoAq) pkg> add https://github.com/TimG1964/XLSX.jl#Add-Row-Ranges-to-formatting

although I can’t get it to work for the Bug-fixing-post-#289 branch, Pkg claims it can’t find that rev in the repo, maybe because it gets confused by the # in the branch name (I did try the URL Bug-fixing-post-%23289 as well to no avail)

27

Does that merit an issue on Pkg, or is # something I shouldn’t have used in the branch name?

28

I honestly don’t know, my first guess is that I’m too dumb to properly escape the # character and there’s a way to make it work.

29

@TimG I would also try to reach out to @felipenoris to see if he could add you as the new maintainer of the original XLSX.jl package. I believe he is not using Julia these days.