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

1 vote283 views1 answer
Python function remove all whitespace from all character columns in dataframe
Python
1 vote277 views1 answer
Pandas sample rows
Python
0 vote282 views1 answer
Qlcdnumber set value python
Python
8 votes261 views2 answers
How to move a column in pandas dataframe
Python
0 vote264 views1 answer
How to access http page in pythion
Python
-1 vote291 views1 answer
TypeError: cannot unpack non-iterable float object evaluate
Python
0 vote252 views1 answer
How to capture video in google colab with python
Python
1 vote294 views1 answer
Sort python dictionary by date
Python
28 votes266 views4 answers
Seaborn figure size
Python
0 vote243 views2 answers
What is the tracing output of the code below x=10 y=50 if(x**2> 100 and y <100): print(x,y)
Python