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

4 votes220 views2 answers
Make a nested list flat python
Python
1 vote203 views1 answer
How to add a number to every element in a list python
Python
0 vote201 views1 answer
Python create a pinging sound
Python
37 votes250 views6 answers
How to convert list into string in python
Python
0 vote286 views2 answers
Django-filter
Python
0 vote327 views1 answer
Python loop break on keypress
Python
0 vote208 views1 answer
Coefficient of variation python
Python
2 votes221 views2 answers
Pandas divide one column by another
Python
0 vote186 views1 answer
How to plot labeled data with different colors
Python
8 votes201 views1 answer
Printing python dictionary values
Python