Pandas add new data to excel sheet without deleting old data in excel file

I am trying to add new data to excel sheet from pandas library. Now I am needed to add new data without deleting old data in excel sheet. How can me do this? My code:

editableExcelSheet = pd.ExcelWriter(r'D:\Projects\MOJ\MOJ.xlsx', engine='openpyxl', mode="a", if_sheet_exists='overlay')
serialNumberFromSheet_htmlName = request.form.get("serialNumberFromSheet_htmlName")
dataSet = {'SerialNumber': [serialNumberFromSheet_htmlName]}
newCase = pd.DataFrame(dataSet)
newCase.to_excel(startrow=editableExcelSheet.max_row, sheet_name='Sheet1')
editableExcelSheet.save()

Comment From: phofl

Hi, this is what excel writer is for, https://pandas.pydata.org/docs/reference/api/pandas.ExcelWriter.html This has an append mode. Please ask usage questions on stack overflow