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 vote150 views1 answer
How to crack a 4 way handshake with python
Python
0 vote145 views1 answer
Python count bits
Python
0 vote163 views2 answers
Python generate secret key
Python
0 vote275 views1 answer
Flask on gevent over https
Python
12 votes160 views5 answers
Conda python update
Python
0 vote149 views1 answer
How to download a project from pythonanywhere
Python
0 vote149 views1 answer
Tensor.numpy() pytorch gpu
Python
0 vote155 views1 answer
Raise keyerror(key) from none os.environ
Python
0 vote143 views1 answer
Python in a nutshell
Python
5 votes157 views6 answers
Python pytube
Python