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

16 votes154 views1 answer
Print surrent directory python
Python
0 vote147 views1 answer
Python pass command is 'Do Nothing'
Python
0 vote146 views1 answer
How to define an empyt dic tin python
Python
0 vote145 views1 answer
Apply strip() a column in pandas
Python
2 votes171 views2 answers
Create django user command line
Python Django
0 vote156 views2 answers
Make entry bigger in tkinter python
Python
0 vote195 views1 answer
Theta hat symbol python code
Python
0 vote187 views1 answer
Flask migrate multiple heads
Python Flask
4 votes150 views2 answers
How to count non null values in pandas
Python
0 vote149 views1 answer
Python display name plot
Python