在python中用pandas中的to_excel保存文件时,会将原文件的sheet进行覆盖,无法将处理后的结果保存在读取的文件中,采用openpyxl模块可以解决这个问题,方法如下
例子
import openpyxl
import pandas as pd
path = r"C:\Users\john\Desktop\test.xlsx"
df = pd.read_excel(path,index_col=None)
Result = df.head()
excel_writer = pd.ExcelWriter(path, engine='openpyxl')
book = openpyxl.load_workbook(excel_writer.path)
excel_writer.book = book
Result.to_excel(excel_writer=excel_writer, sheet_name= 'test', index=None)
excel_writer.close()