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

8 votes214 views3 answers
Sklearn roc curve
Python
0 vote196 views1 answer
How to run django tests
Python
1 vote223 views1 answer
__file__ python
Python
0 vote232 views1 answer
Tkinter gui grid and frame
Python
0 vote219 views1 answer
Django bootstrap
Python Django
2 votes214 views1 answer
Python string formatting escape curly brace
Python
0 vote231 views1 answer
Datafram combine 3 columns to datetime
Python
7 votes211 views2 answers
Whatapp
Python
7 votes228 views4 answers
How to count number of columns in dataframe python
Python
81 votes203 views6 answers
String to date python
Python