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 vote261 views2 answers
Scikit learn to identify highly correlated features
Python
12 votes268 views3 answers
Python print on file
Python
15 votes331 views6 answers
Infinity python
Python
3 votes264 views2 answers
Python obfuscator
Python
1 vote257 views1 answer
Get list from list python
Python
0 vote258 views1 answer
Cv2 opencv-python imshow while loop
Python
0 vote292 views1 answer
Parquet pyspark
Python
0 vote280 views1 answer
Separate path python
Python
52 votes299 views2 answers
Python - remove duplicate items from the list
Python
2 votes292 views1 answer
Matplotlib savefig not working
Python