XLSX.jl merging and formatting cells in Excel file?

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

1 Like

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 :slight_smile:

1 Like