openpyxlで列幅を調整する

adjust_column_width.py

# https://stackoverflow.com/questions/39529662/python-automatically-adjust-width-of-an-excel-files-columns
# これのサンプルコードが動かないので直したもの
def adjust_col(ws):
    for col in ws.columns:
         max_length = 0
         column = col[0].column # Get the column name
         column = chr(ord("A") - 1 + column)
         for cell in col:
             try: # Necessary to avoid error on empty cells
                 if len(str(cell.value)) > max_length:
                     max_length = len(cell.value)
             except:
                 pass
         adjusted_width = (max_length + 2) * 1.1
         ws.column_dimensions[column].width = adjusted_width