df=pd.read_excel(r"file_path",encoding='GB18030')
excelWriter=pd.ExcelWriter (r"file_path")
df.to_excel(excel_writer=excelWriter, sheet_name="1",index=None)
df.to_excel(excel_writer=excelWriter, sheet_name="2",index=None)
excelWriter.save()
excelWriter.close()
python 在同一个excel的不同sheet里写入数据
最新推荐文章于 2024-04-25 10:21:17 发布