Oct-14-2019, 10:35 AM
Using openpyxl, I cannot figure out how to apply a row height on an existing worksheet unless I do it one row at a time.
This works for a single row:
This approach does nothing yet does not throw an error:
This works for a single row:
ws4.row_dimensions[14].height = 25But I want to set the row height for row 7 and any subsequent rows.
This approach does nothing yet does not throw an error:
for rows in ws4.iter_rows(min_row=7, max_row=None): ws4.row_dimensions.height = 25 wb4.save('C:\\folder\\DataplusRows.xlsx')Any idea how to do this? I can't glean the answer from the openpyxl documentation. And I can't seem to find examples anywhere.