I hope it is OK to revive this topic. It is the only [ANN] topic I could find relating to XLSX.jl. Happy for it to be moved if that is appropriate.
I have been working on some significant updates to the package recently and have made a series of pull requests. However, the changes I’ve made are quite large and I’m still learning julia, so I wanted to ask if anyone was interested in trying out my updates before @felipenoris creates a new release (if indeed he should).
A fork of the package with my updates can be found here [Edit: link updated latest branch].
In summary, here is a quick list of the functionality I’ve added:
-
Fairly comprehensive options to control the formatting of cells and cell ranges. This makes it easy to control things like the font characteristics, alignment, colour, size, etc, cell fill colour and pattern, cell borders, change column width or row height, etc, and to apply conditional formatting to cells. Support is provided for much easier number formatting, too. More detail can be found here.
-
Cell formatting in templates is retained when cells are written - previously, default formats were used when writing values, removing any borders, shading, alignment, etc, originally in the template. This change makes templates much more useful. Details here.
-
Pretty full functionality now for both row ranges and non-contiguous ranges (How to get a single row just by a row number? #150, indexing Rows with vectors #88, for example)
-
normalizenameskeyword forreadtable()(Offernormalizenames? #260) -
Extended range of value types that
writetable()can use (Can supported types (for writing to Excel) be expanded - similar to CSV.write ? #239) -
Ability to inspect merged cells (Handling of the merged cells #241)
-
Ability to add additional
definedNames(Defining named ranges #148) -
Docstrings for all of the above
Formatting of cells, in particular, seems to have given rise to many issues and some discussion. For example, I think my changes address the following formatting issues: #281, #275, #259, #234, #63 and #52 (partly). They also address the questions raised on the discourse here, here (formatting but not and now merging, too), and possibly here, too.
I would welcome feedback on this PR if any one wants to give it a try. I’ll do my best to fix any issues.
I’d like to thank @felipenoris for his work to develop the package in the first place. I’d also like to thank @nhz2 for his early suggestions for improvement. I’m sure the community will be able to come up with many more!