XLSX.jl How merging and formatting cells in Excel file?
1 How to combine/merge cells in a worksheet e.g. A1: C3
2. How to format table boundaries
Paul
XLSX.jl How merging and formatting cells in Excel file?
1 How to combine/merge cells in a worksheet e.g. A1: C3
2. How to format table boundaries
Paul
Well unfortunately XLSX.jl doesn’t provide any functionality for formatting. So merging cells with XLSX.jl is impossible
Any other way in Julia ? Other packages?
Paul
Using PyCall
to call openpyxl
. See this post and this article.
ExcelReaders.jl uses python package xlrd, and xlrd seems to have more functionalities regarding formatting. API Reference — xlrd 2.0.1 documentation
You probably can use xlrd functions from Julia but I’m not sure, because I’ve never used them myself