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 votes132 views4 answers
Check cuda version python
Python
22 votes117 views2 answers
Python count repeated elements in a list
Python
0 vote120 views1 answer
Json dumps indent
Python
5 votes160 views1 answer
Python string match ignore case
Python
0 vote122 views1 answer
Check if a numpy array contains only 1's python
Python
1 vote121 views1 answer
What is values_list in django orm
Python
0 vote122 views1 answer
Numpy euclidean distance matrix broadcasting
Python
0 vote123 views1 answer
True Positive, True Negative, False Positive, False Negative in scikit learn
Python
1 vote115 views1 answer
Getting multiple selected value django
Python
3 votes132 views1 answer
How to write to a file in python without deleting all content
Python