采用to_excel保存文件不覆盖原有的sheet

在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()