首先创建需要另存为目标Excel表至writer1,
ExcelPath:可以自己拟定
nowExcelPath:这个是目前有的Excel表,需要往里面添加数据的
创建writer、writer1
writer1=pd.ExcelWriter(ExcelPath,engine='openpyxl')
writer=pd.ExcelWriter(nowExcelPath,engine='openpyxl')
创建book
book=openpyxl.load_workbook(writer.path)
将book赋值给新建的writer1.book:
writer1.book=book
df是dataframe数据
df.to_excel(writer1,'sheetname',index=False)
writer.close()
writer1.save()
writer1.close()
注意:不用存储writer.save()就不会覆盖原来的Excel表
希望能帮助到大家