Merging and formatting cells in Excel from Julia

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