import pandas as pd
# 创建一个输出文件 writer = pd.ExcelWriter('E:/test/he.xlsx') data = pd.read_table('E:/test/chuncker.csv',sep=',',encoding='GBK') data.to_excel(writer,'data',index=False) base = pd.read_excel('E:/test/test3.xlsx','Sheet1') base.to_excel(writer,'base',index=False) base1 = pd.read_csv('E:/test/test4.csv') base1.to_excel(writer,'base1',index=False) #保存 writer.save()
python 把多个excel、csv写成同一excel多个sheet
最新推荐文章于 2023-10-19 17:27:11 发布