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 votes234 views1 answer
Input stdin python
Python
0 vote252 views1 answer
Copy data with tensroflow io
Python
1 vote248 views1 answer
Python index 2d array
Python
0 vote269 views1 answer
Proper pagination django template
Python Django
4 votes268 views2 answers
Declare array with given size python
Python
125 votes232 views6 answers
How to change column name in pandas
Python
1 vote251 views1 answer
Difference between loc and iloc
Python
0 vote246 views1 answer
How to change the colour of axes in matplotlin
Python
30 votes257 views3 answers
How to get decimal part of a double in python
Python
0 vote257 views1 answer
Pandas change to first day
Python