pandas to_excel append add sheet with increased index code example
Example: 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)