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 vote116 views1 answer
What does 0 for in array mean python
Python
1 vote102 views1 answer
Convert arrary to int
Python
0 vote101 views1 answer
Python3 change file permissions
Python
29 votes105 views5 answers
List comprehension python if else
Python
1 vote97 views1 answer
Python implode list
Python
0 vote119 views1 answer
How to store a int value in django sessions
Python
0 vote116 views1 answer
Image resolution extracting python
Python
3 votes127 views2 answers
How to make a grid in python
Python
2 votes99 views1 answer
Np logical_or
Python
1 vote104 views1 answer
Mean Kurtosis of all rows pandas
Python