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

10 votes118 views3 answers
Count occurrence in array python
Python
0 vote136 views1 answer
Connect snowflake with python
Python
-1 vote146 views1 answer
List of letter in word python
Python
0 vote130 views1 answer
Install python windows powershell
Python
2 votes122 views1 answer
Display python 001
Python
0 vote132 views1 answer
How long is the pyautogui script
Python
0 vote138 views1 answer
See python function details in vscode
Python
0 vote133 views1 answer
Colorama input python
Python
1 vote119 views1 answer
Create a vector of zeros in r
Python
4 votes138 views2 answers
Discord py color
Python