将数据追加到现有Excel工作表中的问题

Question

我在将数据添加到excel文件的现有工作表时遇到问题。 下面是代码，它从excel文件中提取记录的最后日期，创建带有增量记录的新df，我正在尝试将新记录附加到同一张excel文件中

import pandas as pd
import datetime as dt
import yfinance as yf
from openpyxl import load_workbook

ticker = 'AXISBANK.NS'

ef = pd.read_excel('D:/YProject/'+ticker+'.xlsx', sheet_name = 'Daily') 


en = dt.datetime.today()+ dt.timedelta(days=1)
st = ef.Date.max()+ dt.timedelta(days=1)
df = yf.download(ticker, start =st, end =en, interval ='1d').drop(['Adj Close'], axis = 1).reset_index()

writer = pd.ExcelWriter('D:/YProject/'+ticker+'.xlsx',engine='openpyxl', mode='a')
writer.book = load_workbook('D:/YProject/'+ticker+'.xlsx')
df.to_excel(writer, sheet_name = 'Daily',header='false')
writer.save()
writer.close()
print(df)

此代码创建新工作表，但不附加工作表