Merging and formatting cells in Excel from Julia

General Usage
, ,
1

Hello,

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.

2

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")
ws[:merge_cells]("A1:D3")
wb[:save]("test.xlsx")
3 Likes
3

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