Question: Dash export all with page register and dash ag grid

Dash Python
1

I would like to implement a download all function which allows me to download all pages (10+) in one go using ag grid export multiple excel sheets api. Inside of each page (each page connects to different tables), I did data aggregation, (renaming, pivot…) and since I also use ag grid row grouping feature, I also define columnDef for each dataset. Therefore I dont wanna to duplicate those steps/work, instead I would like to directly import those dash girds into a separate py file. I am not sure if it is allowed to import this pages(df,columndef,dashgrids) now due to this duplicate module error, also not sure if I do this download all function in a wise way.

It will be really appreciated if you can give some suggestions to solve duplicate path issue or any better ideas to implement download all pages function.

  • db.py
  • pages
    |-- home.py
    -chapter1
    |-- page1.py
    |-- page2.py
    |-- page…py
    -chapter2
    -chapter3
    |-- page1.py
    |-- page2.py
2

@jinnyzor Hi I opened a new topic regarding the duplicate path issues I asked in another topic. Thank you!

1 Like
3

Hi @hwang

Could you please provide a little more information?

Are you trying to save a snapshot of the grids on all the different pages - after callbacks and user interaction? If so, that is not a simple thing to do.

If you would like to create a new page with the initial grid definitions on each page, that would be possible, but the dash.register_page would need to be called from app.py.

4

Thanks for that issue I think I have found a way to solve it. But I have another question, really appreicated if you can help.

I would like to create a button on of the app narvbar (Instead of creating a page which only has one download button), when users clicked, it downloads all girds (I save these grids in a separate py file). I have already use clientside_callback to trigger a download. Not sure if it is possible to achieve?

`clientside_callback(
“”"
function(n) {
if (n) {
var spreadsheets = ;
spreadsheets.push(
dash_ag_grid.getApi(“report1”).getSheetDataForExcel({ sheetName: ‘Current Month’ }),
dash_ag_grid.getApi(“report2”).getSheetDataForExcel({ sheetName: ‘Sales’ }),
dash_ag_grid.getApi(“report3”).getSheetDataForExcel({ sheetName: ‘Product)’ }),

        );
        dash_ag_grid.getApi("total").exportMultipleSheetsAsExcel({ data: spreadsheets, fileName: 'report.xlsx' });
    }
    return dash_clientside.no_update;
}
""",
Output("btn-excel-export-multiple-sheets", "n_clicks"),
Input("btn-excel-export-multiple-sheets", "n_clicks"),
prevent_initial_call=True

)`

  • db.py
  • narbvar.py
  • grid.py (where I store all grids)
  • pages
    -chapter1
    |-- page1.py
    |-- page2.py
    |-- page…py
    -chapter2
    -chapter3
    |-- page1.py
    |-- page2.py
5

All the grids would have to exist in the DOM for this to work. You would have to be on the page that included all the grids you want to download.

1 Like