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

6 votes308 views2 answers
Python check if folder is empty
Python
1 vote279 views1 answer
Python program to give shop name
Python
2 votes284 views1 answer
Remove negative numbers from list python
Python
22 votes269 views6 answers
Sort key python
Python
2 votes301 views2 answers
How to show process bar in terminal python
Python
0 vote285 views1 answer
Split python strings into pairs & complete uneven pairs
Python
0 vote283 views1 answer
Pydub create empty track
Python
2 votes295 views4 answers
ValueError: Input contains NaN, infinity or a value too large for dtype('float32').
Python
7 votes313 views2 answers
How to create a variablein python
Python
0 vote306 views1 answer
Python hex to bytes string
Python