def dfs_tabs(df_list, sheet_list, file_name):
    writer = pd.ExcelWriter(file_name, engine='xlsxwriter')
for dataframe, sheet in zip(df_list, sheet_list):
    dataframe.to_excel(writer, sheet_name=sheet, startrow=0, startcol=0)
writer.save()
dfs = [df, df1, df2]
sheets = ['df', 'df1', 'df2']
dfs_tabs(dfs, sheets, 'multi-test.xlsx')
Putting many python pandas dataframes to one excel worksheet