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 vote518 views1 answer
Backup django db from one database to another
Python Django
0 vote328 views2 answers
Insert character into string at position x python
Python
0 vote347 views1 answer
Save a seaborn heatmap
Python
5 votes341 views2 answers
Python check if a file is empty
Python
0 vote349 views1 answer
How to save model to a file python
Python
0 vote334 views1 answer
How to make python turn a list into a text file grapper
Python
1 vote376 views2 answers
Python error get line
Python
8 votes365 views4 answers
Remove nan from list python
Python
10 votes334 views2 answers
Create dict from json file python
Python
0 vote327 views1 answer
Pandas typr of each cell in series
Python