[Datatable] Export with formatting

[jinnyzor]

Sure, what you can do is write to an io, format the excel file as you desire and then use dcc.send_bytes() with your formatted excel file. All to the dcc.Download.

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…