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

18 votes320 views2 answers
Python end script
Python
12 votes312 views6 answers
How to import matplotlib in python
Python
0 vote319 views1 answer
Pyplot new figure
Python
2 votes300 views1 answer
How to set chrome options python selenium for a folder
Python
0 vote297 views1 answer
Struct trong python
Python
-3 votes315 views1 answer
How to program a virus in python
Python
1 vote332 views1 answer
Django round 2 decimal
Python
-1 vote299 views1 answer
Car python program
Python
1 vote328 views2 answers
Types of all columns pandas
Python
1 vote317 views1 answer
Python delete dict key if exists
Python