writer = pd.ExcelWriter(r'C:\TEMP\工作簿.xlsx')
df1.to_excel(writer,'工作表1')
df2.to_excel(writer,'工作表2',index=True)
writer.save()
writer.close()
多个DataFrame保存到Excel同一个工作簿不同工作表
最新推荐文章于 2024-10-08 12:37:10 发布
writer = pd.ExcelWriter(r'C:\TEMP\工作簿.xlsx')
df1.to_excel(writer,'工作表1')
df2.to_excel(writer,'工作表2',index=True)
writer.save()
writer.close()