search

plotly / dash-pivottable

react-pivottable in Dash
MIT License
192 stars 52 forks source link

Is it possible to export to excel? #5

Closed happyshows closed 5 years ago

happyshows commented 5 years ago

Hi,

This is handy and end user will probably ask for how to export the pivoted data. Is export to excel an option? Or it depends on react-pivotable to implement certain interface?

xhluca commented 5 years ago

It's solely based on react-pivottable feature wise. You can create a callback that lets you retrieve the data inside the current view (by filtering your original data using the rows and cols that are currently selected; pretty easily done in pandas).

Then once you have that filtered dataframe, you can export it into CSV, then use the method discussed in this thread to let the user download the file.

happyshows commented 5 years ago

Thanks.

rdkbruce commented 2 years ago

@happyshows Were you able to achieve the file export? If yes, could you please outline how you did it? thanks