python导出excel

def excel(data, titles):
    # 创建一个新的工作簿
    wb = Workbook()
    # 选择活动工作表
    ws = wb.active
    # 表头
    row = 1
    column = 0
    for it in titles:
        if it["boot"] == 1:
            column = column + 1
            ws.cell(row=row, column=column).value = it["labelName"]

    # 数据
    for it in data:
        row = row + 1
        column = 0
        for it1 in titles:
            if it1["boot"] == 1:
                column = column + 1
                # 判断字段是否存在字典中
                if it1['prop'] in it:
                    ws.cell(row=row, column=column).value = it[it1['prop']]

    # 冻结首行
    ws.freeze_panes = 'A2'


    # 2024-07-24 23:21:50
    page = time.strftime("%Y%m%d", time.localtime())
    # 获得项目路径
    project_path = os.getcwd()
    # 判断目录不存在创建
    if not os.path.exists(f"{project_path}/static/{page}"):
        os.makedirs(f"{project_path}/static/{page}")
    # 报表名称
    name = "采购开单明细表"+time.strftime("%Y_%m_%d_%H_%M_%S", time.localtime())
    # 保存工作簿
    wb.save(f'{project_path}/static/{page}/{name}.xlsx')
    # 返回文件路径
    return f'/static/{page}/{name}.xlsx'