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

7 votes298 views4 answers
'numpy.ndarray' object is not callable
Python
5 votes357 views1 answer
Series vs dataframe
Python
9 votes352 views6 answers
Add list python
Python
2 votes384 views1 answer
Django create model from dictionary
Python
6 votes339 views2 answers
Tkinter template
Python
8 votes319 views1 answer
Remove strings from a list python if they're short
Python
0 vote353 views1 answer
Turn off subplot
Python
30 votes355 views3 answers
Django create superuser from script
Python
1 vote342 views1 answer
Final class variable python
Python
1 vote351 views1 answer
How to sort in greatest to least python
Python