python 把多个excel、csv写成同一excel多个sheet

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()