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

2 votes226 views1 answer
Name unnamed column pandas
Python
1 vote187 views1 answer
Pyhton turtle delete
Python
19 votes169 views5 answers
Replace key of dictionary python
Python
0 vote188 views1 answer
Mp.solutions.findhands not in python 3.8
Python
14 votes161 views2 answers
How to check if a dictionary is empty in python
Python
2 votes199 views1 answer
Printing with format float to 2 decimal places python
Python
0 vote155 views1 answer
Combine date and time python
Python
1 vote161 views1 answer
Convert negative to zero in list in python
Python
-1 vote177 views1 answer
With urllib.request.urlopen("https://
Python
0 vote227 views1 answer
Streamlit bold
Python