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

Community
,
41

I have not experience with hosting docs on github, but maybe you could add another (temporary ?) shield for your docs if you already build them ?

42

The changes documented above and a host of others have now been merged into the #master branch of XLSX.jl. The revised docs are also linked as the Dev docs, too.

I have one further PR that is waiting to merge which adds a setFormula function, allowing you to add any Excel function to a cell or cell range from XLSX.jl and properly respects absolute and relative cell addressing.

julia> setFormula(sheet, "B2:J10", "=A2+B1") # Adds simple formula to a range of cells.

julia> setFormula(sheet, "E1:G1", "=sort(unique(A2:A7),,-1)") # adds a dynamic array function with a spill range.

julia> setFormula(sheet, "C1", " = max(B1#)") # Applies max() to the collected values in the spill range of B1.

@felipenoris has tagged the #master branch as v0.11.0 so Iā€™m hoping a new release is coming soon!

17 Likes