pandas 读写excel

最新推荐文章于 2024-09-27 16:52:53 发布

hellenlee22

最新推荐文章于 2024-09-27 16:52:53 发布

阅读量178

点赞数 1

分类专栏： python

本文链接：https://blog.csdn.net/hellenlee22/article/details/104826480

版权

python 专栏收录该内容

44 篇文章 1 订阅

订阅专栏

pandas 读写excel

>>>import pandas as  pd

>>> 
excel_path = r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.11.xlsx"

>>> data=pd.read_excel(excel_path)
>>> writer=pd.ExcelWriter(r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.111.xlsx")
>>> data.to_excel(writer,'sheet1',index=False)
>>> writer.save()
>>> writer=pd.ExcelWriter(r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.112.xlsx")
>>> data.to_excel(writer,'sheet1',index=False)
>>> writer.save()
>>>

参考：https://blog.csdn.net/jingyi130705008/article/details/100741205