python + openpyxl 输出Excel单元格大小自适应和填充

from openpyxl import load_workbook
from openpyxl.styles import Color,Font,Alignment,PatternFill,Border,Side,Protection
 
#将列数转成列名对应单元格
def num2column(num):
    interval = ord('Z') - ord('A')
    tmp = ''
    multiple = num // interval
    remainder = num % interval
    while multiple > 0:
        if multiple > 25:
            tmp += 'A'
        else:
            tmp += chr(64 + multiple)
        multiple = multiple // interval
    tmp += chr(64 + remainder)
    return tmp
 
# 对Excel格式进行设置
def func_openpyxl_modify_excel(out_file, df_list, No_list):
    wb = load_workbook(out_file)
    ws_list = wb.sheetnames
 
    border = Border(left=Side(style='thin', color='FF000000'),
                    right=Side(style='thin', color='FF000000'),
                    top=Side(style='thin', color='