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

0 vote178 views1 answer
Python using string to access objects
Python
0 vote134 views1 answer
Discord.py get server id
Python
8 votes128 views1 answer
Pygame draw rect syntax
Python
0 vote92 views1 answer
Pygame triangle
Python
0 vote169 views1 answer
Django require_POST body
Python Django
1 vote130 views2 answers
Update python 3.9
Python
0 vote147 views1 answer
Sns regplot make the line and confidence interval thicker
Python
0 vote127 views1 answer
Shotgun filter any
Python
0 vote139 views1 answer
Python write data to file with permissions
Python
0 vote159 views1 answer
How to return an html file in flask
Python Flask