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 vote256 views1 answer
Isidentifier method in python
Python
0 vote224 views1 answer
Validate string using six library python
Python
-1 vote235 views1 answer
Pandas df multiindex
Python
62 votes236 views6 answers
Class python
Python
26 votes224 views1 answer
Module 'tensorflow.python.framework.ops' has no attribute '_tensorlike'
Python
0 vote240 views1 answer
Textrank python implementation
Python
3 votes249 views2 answers
Update_or_create django
Python
25 votes226 views2 answers
Django create app command
Python
0 vote223 views1 answer
Inpuit inf terfminal ppython
Python
0 vote203 views1 answer
How to save string json to json object python
Python