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:
However in Julia when I use openpyxl and try to do the same it does not work, because ws.column_dimensions is an empty dictionary
using Conda Conda.add("openpyxl") using PyCall xl = pyimport("openpyxl") # create a workbook wb = xl.Workbook() # select active worksheet ws = wb.active # try to change the width of the column A --> NOT working ws.column_dimensions["A"].width = 25
The same problem exists if I try to change the height of the first row using
ws.row_dimensions.height = 30