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 vote152 views1 answer
Python find if part of list is in list
Python
0 vote175 views1 answer
Split list in 3 part
Python
0 vote167 views1 answer
How to add column to heroku postgres in my django app
Python Django
-1 vote136 views1 answer
Show all text contained in a line pandaq
Python
1 vote146 views1 answer
Python choose sample from list with replacement
Python
0 vote134 views1 answer
Django form label in template
Python
0 vote141 views1 answer
Pandas group by multiple columns and count
Python
0 vote159 views1 answer
Absolute value of int python
Python
4 votes129 views1 answer
Drop Rows by Index in dataframe
Python
4 votes143 views3 answers
Django Change Password
Python