How to set the default row and column height in openpyxl?

Question

I would like to change the row and column height using Openpyxl. I can change the specific row and height by apply this

import openpyxl
wb = openpyxl.Workbook()
ws = wb.active
ws.row_dimensions[1].height = 10

But I want to change the default height and width of rows and column so that I dont have to apply in each rows and cols.

Is it possible to do this ?

Answer 1

Please take a look at this post:-

https://stackoverflow.com/questions/13197574/openpyxl-adjust-column-width-size