python3 Excel 列幅を指定する

import openpyxl as px

filepath = r'c:\sample/excel_test/test.xlsx'
savepath = r'c:\sample/excel_test/test2.xlsx'
wb = px.load_workbook(filepath)
ws = wb.get_sheet_by_name('Sheet1')

for i in range(ord('A'),ord('Z')+1):
    ws.column_dimensions[chr(i)].width = 15

wb.save(savepath)