python pandas append rows to excel keeping formatting code example

Example 1: pandas excel writer append in row

startrow = writer.sheets['Sheet1'].max_row

Example 2: pandas excel writer append in row

for sheetname in writer.sheets:
    df1.to_excel(writer,sheet_name=sheetname, startrow=writer.sheets[sheetname].max_row, index = False,header= False)