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 vote106 views1 answer
Difference between calling a function and referencing a function python
Python
0 vote75 views1 answer
Algorithme pour afficher table de multiplication python
Python
0 vote109 views1 answer
How to download feature engine in spyder console
Python
1 vote127 views1 answer
Django wait for database
Python Django
0 vote105 views1 answer
Python dash bootstrap buttons with icons
Python
16 votes111 views4 answers
Random.choice
Python
0 vote97 views1 answer
57 *2
Python
6 votes105 views6 answers
Palindrome
Python
0 vote138 views1 answer
Django send_mail not working in testcase
Python Django
0 vote98 views1 answer
Flask windows auto reload
Python