# 方法1
writer = pd.ExcelWriter('data.xlsx')
data1.to_excel(writer, 'sheet1')
data2.to_excel(writer, 'sheet2')
writer.save()
writer.close()
# 方法2
with pd.ExcelWriter('data.xlsx') as writer:
data1.to_excel(writer, 'sheet1')
data2.to_excel(writer, 'sheet2')
python导出多个Dataframe存放同一Excel中
最新推荐文章于 2023-07-12 11:27:00 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)