if os.path.exists('C:\\Full Location\\To\\excelsheet.xlsm'):
    xlApp = win32com.client.Dispatch('Excel.Application')
wb = xlApp.Workbooks.Open(Filename='C:\\Full Location\\To\\excelsheet.xlsm')
xlApp.Run('ClearExistingContent')
wb.Save()
xlApp.Quit()
del xl
writer = ExcelWriter('C:\\Full Location\\To\\excelsheet.xlsm')
yourdf.to_excel(writer, 'Sheet5')
writer.save()
Pandas Dataframe to excel sheet