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
Error with Openpyxl: Pyimport is not in current path Data data	14	1424	April 2, 2019
Merging and formatting cells in Excel from Julia General Usage question , package , xlsx	2	1268	December 18, 2018
ERROR: LoadError: PyError ($(Expr(:escape, :(ccall(#= New to Julia question	2	2536	May 31, 2021
PyCall issue appearing with Julia 0.5.1 (0.4.7 worked fine) General Usage pycall	2	727	May 1, 2017
PyCall and ExcelReaders error Juno	3	1360	March 29, 2020

Julia using openpyxl to change column width & row height

Related topics