Hi all, I am using Julia 1.5.0 with openpyxl and I want to change the column width in an excel worksheet. The python way to this is depicted here: https://stackoverflow.com/questions/53906532/is-it-possible-to-change-the-column-width-using-openpyxl/53906585 However in Julia when I use openpyxl a…

For some reason putting the width setting inside py"""...""" works. using PyCall xl = pyimport("openpyxl") wb = xl.Workbook() ws = wb.active # ws.column_dimensions["A"].width = 25 ## ERROR: KeyError: key "A" not found py""" $ws.column_dimensions["A"].width = 25 """ wb.save("foo.xlsx")

Julia using openpyxl to change column width & row height

General Usage

Emmanouil_Bakirtzis January 9, 2021, 1:45pm 5

@raph this is python, not julia… or am I missing something?

Topic		Replies	Views
Merging and formatting cells in Excel from Julia General Usage question , package , xlsx	2	1225	December 18, 2018
Error with Openpyxl: Pyimport is not in current path Data data	14	1348	April 2, 2019
Cant add or create new column for my data csv General Usage question	1	66	January 20, 2025
PyCall issue appearing with Julia 0.5.1 (0.4.7 worked fine) General Usage pycall	2	704	May 1, 2017
Trouble editing excel file using XLSX.jl package. New to Julia	14	2565	October 18, 2019

Julia using openpyxl to change column width & row height

Related topics