Generate multiple tabs in Excel file with dcc.send_data_frame()

[Emil]

I think the answer is here,

Download excel file with multiple sheets with dataframes

You should loop the sheets inside the to_xlsx function, i.e. something like def make_report(i, my_start_date, my_end_date): df = pd.read_csv('query_ga.csv') df_new = df.loc[df['Report Name'].isin(['{}'.format(i)]) & df['Email ID'].isin(['{}'.format(my_email)])] my_client_id = df_new['Ad Account id'].iat[0] my_client_secret = df_new['App secret'].iat[0] my_refresh_token = df_new['Access token'].iat[0] my_dim = df_new['Dimensions'].iat[0] my_dimensions = ast.literal_ev…