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 vote285 views1 answer
Python string match http
Python
24 votes294 views1 answer
Creating a new enviroment in conda
Python
7 votes314 views1 answer
How to slicing dataframe using two conditions
Python
1 vote343 views2 answers
Pandas sort values group by
Python
0 vote282 views1 answer
How to calculate division with remainder in python
Python
0 vote288 views1 answer
Open a web page using selenium python
Python
4 votes294 views2 answers
Python print binary tree
Python
1 vote262 views1 answer
Subset a list python
Python
0 vote285 views1 answer
Subprocess ffmpeg x265 codec
Python
1 vote305 views1 answer
Pandas string does not contain
Python