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 vote309 views1 answer
Decode multipart/form-data python lambda
Python
0 vote323 views1 answer
Django request.data example
Python Django
8 votes268 views2 answers
Python selenium get image src
Python
4 votes268 views3 answers
List element swapping python
Python
0 vote259 views3 answers
Captcha.image install in python
Python
109 votes276 views6 answers
Python check if string contains substring
Python
0 vote265 views1 answer
What is iterator in python
Python
0 vote295 views1 answer
How to view back of list in python
Python
0 vote283 views2 answers
@methodclass in python
Python
3 votes297 views2 answers
TypeError: 'numpy.ndarray' object is not callable
Python