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

2 votes113 views1 answer
Python 3.7 tutorial pdf with exercises
Python
6 votes117 views3 answers
Cosine similarity python numpy
Python
2 votes109 views3 answers
Sum elements array with step numy
Python
6 votes107 views3 answers
Get particular columns from dataframe
Python
14 votes110 views3 answers
How to find highest number in list without using max function python
Python
21 votes114 views4 answers
Get list input from user in python
Python
8 votes107 views1 answer
ValueError: invalid literal for int() with base 10: site:stackoverflow.com
Python
3 votes125 views1 answer
Python invert an array
Python
0 vote99 views1 answer
Qtile: latest development version
Python
3 votes104 views1 answer
Discord python webhook
Python