pandas创建excel

# 创建excel
data_report_task_item_detail_excel = pd.DataFrame(
    columns=[
        "item_id",
        "taskId",
        "taskName",
        "flowStateId",
        "targetTableId",
        "targetTableValue",
        "controlName",
        "value",
    ]
)

# 创建表头
data_report_task_item_detail_excel.loc[len(data_report_task_item_detail_excel)] = {
    "item_id": "子项ID",
    "taskId": "任务ID",
    "taskName": "任务名称",
    "flowStateId": "关联的明细ID",
    "targetTableId": "目标单位ID",
    "targetTableValue": "目标单位名称",
    "controlName": "项目",
    "value": "值",
}

# 插入数据

        data_report_task_item_detail_excel.loc[
            len(data_report_task_item_detail_excel)
        ] = {
            "item_id": item_id,
            "taskId": taskId,
            "taskName": taskName,
            "flowStateId": flowStateId,
            "targetTableId": targetTableId,
            "targetTableValue": targetTableValue,
            "controlName": controlName,
            "value": value,
        }


# 保存为excel
data_report_task_item_detail_excel.to_excel(
    "data_report_task_item_detail.xlsx", index=False
)