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 vote162 views1 answer
How to create tensor with tensorflow
Python
32 votes193 views2 answers
Drop if nan in column pandas
Python
0 vote163 views1 answer
%%writefile jupyter notebook
Python
4 votes174 views3 answers
Fill nan values with mean
Python
0 vote213 views1 answer
ComplexWarning: Casting complex values to real discards the imaginary part
Python
2 votes174 views1 answer
Python how to get the last element in a list
Python
0 vote159 views1 answer
Bot wait_for discord py
Python
4 votes167 views2 answers
Python run command and read output
Python
0 vote182 views1 answer
Check date on template django
Python Django
0 vote197 views1 answer
How to get parent model object based on child model filter in django
Python Django