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 vote150 views1 answer
Python one line key increment or add
Python
19 votes157 views1 answer
Python cut string to length
Python
0 vote152 views1 answer
Python dt error only use with datetimelike values
Python
0 vote149 views1 answer
Pyaduio linux
Python
2 votes151 views1 answer
How to add headers in csv file using python
Python
0 vote151 views1 answer
Example of input int questions in python with if statement
Python
0 vote155 views1 answer
Py urllib download foto
Python
1 vote160 views1 answer
Python sftp put file
Python
4 votes279 views5 answers
Min max python
Python
0 vote141 views1 answer
Python if condition assignment in one line
Python