Merging and formatting cells in Excel from Julia




Is there a way of merging cells, formatting and aligning cell contents in an Excel file using Julia? Using a package is also fine. I am currently using XLSX.jl to write to Excel files yet for merging, formatting and aligning I would have to explicitly open the Excel file afterwards. I wasn’t sure if XLSX.jl even claimed to provide this functionality so I figured I ought to write this question here.


PyCall and openpyxl work fine, something like

# using Conda; Conda.add("openpyxl")
using PyCall
@pyimport openpyxl
wb = openpyxl.Workbook()
ws = wb[:create_sheet](title="Test1")


Thanks a lot! Works great, has all the functionalities I want.