主要思路先把 list,利用pandas转换成df,然后再输出Excel。 eg: # create list row_list = [['02', '技能属性', '020001', '技术能力', '0200010001', 'IT技术', '02000100010027', 'IT工具', '020001000100270037', 'ffmpeg'], ['02', '技能属性', '020001', '技术能力', '0200010001', 'IT技术', '02000100010027', 'IT工具', '020001000100270038', 'adobe acrobat reader']] # row list to df, then write to excel pd.DataFrame(row_list, columns=["CATEGORY_CODE","CATEGORY_NAME","FIRST_LEVEL_CATEGORY_CODE","FIRST_LEVEL_CATEGORY_NAME","SECOND_LEVEL_CATEGORY_CODE","SECOND_LEVEL_CATEGORY_NAME","THIRD_LEVEL_CATEGORY_CODE","THIRD_LEVEL_CATEGORY_NAME","SKILL_CODE","SKILL_NAME" ]).to_excel("C:/work/20230224**/****-code完成.xlsx", index=False)
输出效果: