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

1 vote310 views1 answer
Python to 32 bit signed float
Python
0 vote311 views1 answer
Symbolic variables python
Python
0 vote311 views1 answer
Plt grid linestyles options
Python
0 vote337 views1 answer
Math expressions with matplotlib
Python
1 vote321 views1 answer
How to use if else to prove a variable even or odd in python
Python
1 vote313 views1 answer
Connecting Kaggle to Google Colab
Python
0 vote322 views1 answer
Odoo - add one2many field programmatically
Python
0 vote303 views1 answer
How to create empty series in pandas
Python
3 votes304 views1 answer
Python array delete last column
Python
0 vote318 views1 answer
Proper pagination django template
Python