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 vote286 views1 answer
Take first n row of dictionary python
Python
1 vote264 views1 answer
Creating an apis with python and flask
Python
0 vote239 views1 answer
UTC to ISO 8601 with Local TimeZone information without microsecond (Python 3):
Python
0 vote256 views1 answer
How to check if a list raises IndexError but wihing a if statement python
Python
4 votes256 views2 answers
Python press any key to continue
Python
24 votes276 views3 answers
Get last n characters of string python
Python
0 vote255 views1 answer
Add_node python
Python
81 votes254 views6 answers
Check python version
Python
0 vote309 views1 answer
Check for duplicate values in dataframe
Python
72 votes267 views4 answers
Setting p a virtual envioronment
Python