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

26 votes194 views4 answers
Python download youtube video
Python
6 votes177 views3 answers
Flask get ip of user
Python Flask
1 vote200 views1 answer
Use incognito in selenium webdriver
Python
1 vote170 views3 answers
Check cuda version pytorch
Python
1 vote168 views1 answer
How to download the captions of a youtube video
Python
10 votes171 views4 answers
Numpy empty array
Python
0 vote175 views5 answers
TypeError: ‘float’ object is not callable
Python
0 vote175 views1 answer
Creating fake instagram accounts with python
Python
0 vote181 views1 answer
Tensorflow io check file exist
Python
0 vote164 views1 answer
Python get list of file and time created
Python