Python openpyxl cell width

from openpyxl.utils import get_column_letter

column_widths = []
for row in Workbook:
    for i, cell in enumerate(row):
        if len(column_widths) > i:
            if len(cell) > column_widths[i]:
                column_widths[i] = len(cell)
        else:
            column_widths += [len(cell)]

for i, column_width in enumerate(column_widths):
    worksheet.column_dimensions[get_column_letter(i+1)].width = column_width

Source: stackoverflow.com

Similar codes

1 vote169 views2 answers
Python timedelta to seconds
Python
3 votes170 views3 answers
Qlabel click python
Python
0 vote178 views1 answer
Telethon send image
Python
0 vote160 views1 answer
Django template date format yyyy-mm-dd
Python Django
0 vote232 views2 answers
How to get every character in a string python
Python
0 vote170 views1 answer
Pyserial read
Python
0 vote193 views3 answers
Missing Data Plotly Express px.data
Python
0 vote164 views1 answer
My Skile
Python
9 votes207 views3 answers
Python venv usage
Python
0 vote273 views1 answer
Python print n numbers
Python