python openpyxl 设置表格列宽的自动适应,Python-自动调整Excel文件列的宽度

Newbie - I have a Python script that adjusts the width of different columns of an excel file, according to the values specified:

import openpyxl

from string import ascii_uppercase

newFile = "D:\Excel Files\abc.xlsx"

wb = openpyxl.load_workbook(filename = newFile)

worksheet = wb.active

for column in ascii_uppercase:

if (column=='A'):

worksheet.column_dimensions[column].width = 30

elif (column=='B'):

worksheet.column_dimensions[column].width = 40

elif (column=='G'):

worksheet.column_dimensions[column].width = 45

else:

worksheet.column_dimensions[column].width = 15

wb.save(newFile)

Is there any way through which we can adjust the width of every column to its most optimum value, wit