Following is my code snippet:
writer = pd.ExcelWriter(path_file, engine= 'openpyxl')
df.to_excel(writer, index= False)
df.to_excel(writer, startrow= len(df), index= False)
df has all the data I need to append.
I have a master excel sheet that is linked to a Tableau workbook.
I have pulled a large amount of data into data frames, and I want to be able to append the data frames to the existing master excel sheet.
The problem right now it is just completely overwriting the file and creating a new copy.