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 vote227 views1 answer
Slicing tuples
Python
0 vote275 views1 answer
Comtypes python
Python
23 votes290 views3 answers
Django drf
Python Django
0 vote225 views1 answer
How to multiply integer value with float values in python
Python
0 vote237 views1 answer
Print without parenthesis
Python
0 vote187 views1 answer
Pandas read all csv in folder
Python
3 votes227 views1 answer
Find angle mbc in python
Python
0 vote236 views1 answer
Python update header row
Python
0 vote222 views1 answer
Turn columns into one column as list python
Python
0 vote211 views1 answer
Python : a counter
Python