import pandas as pd
excelWriter = pd.ExcelWriter("result.xlsx")
for index, name in enumerate(names):
df = pd.read_csv(f"data/{name}.csv", encoding='utf-8')
df.to_excel(excel_writer=excelWriter, sheet_name=name, index=None)
excelWriter.save()
多个CSV写入同一个Excel不同sheet中
最新推荐文章于 2022-06-10 19:16:27 发布