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

5 votes206 views1 answer
Tkinter entry default value
Python
0 vote205 views1 answer
How to convert utf-16 file to utf-8 in python
Python
0 vote185 views1 answer
Getting vocab from a text file python
Python
-1 vote237 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python Django
6 votes189 views1 answer
Utf8 python encodage line
Python
1 vote311 views1 answer
Add search field to django admin
Python Django
16 votes210 views5 answers
Convert pandas dataframe/ table to python dictionary
Python
0 vote210 views2 answers
Flask conditional according to urrl
Python
5 votes209 views2 answers
Print all of dataframe
Python
-1 vote185 views2 answers
How to apply lower string dataframe python
Python