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 vote314 views1 answer
Kroki - hello.dot
Python
1 vote386 views1 answer
Matplotlib log2 xaxis
Python
0 vote328 views1 answer
Label_map dict = label_map_util.get_label_map_dict(label_map)
Python
2 votes310 views1 answer
Shutdown/restart/hibernate/logoff windows with python
Python
0 vote315 views1 answer
Python webdriver disable logs
Python
0 vote308 views1 answer
Ipython list command history
Python
4 votes298 views1 answer
Django objects.create()
Python
0 vote324 views1 answer
Python open dicom file
Python
10 votes362 views1 answer
Python game engine
Python
0 vote351 views1 answer
Django many to many post update method via rest
Python Django