🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

how to export pivot to multi excel or multi sheets files with multi filter

edsion asked on January 19, 2020

Is there a way to export different pivots with different values to different sheets of the same excel file according to the filter values in the pivot, I tried to iterate through the data obtained by getFilter, then call setfilter, and then call exportTo. But because the operation after setfilter is asynchronous, it cannot be used normally

2 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 20, 2020

Thank you for your question.
We would like to kindly inform you that the current version of Flexmonster does not provide a possibility to export different pivots to separate sheets of the same excel file.
As for exports according to the filter values in the pivot, it can be difficult to implement applying multiple filters and exporting them to Excel within the same instance of Flexmonster. Check out an example we have prepared, demonstrating two sequential exports with different filters applied.
However, as a workaround, our team recommend using an approach based on creating a new instance of the component with new filters applied, execute an export from it and remove the created instance.
We are looking forward to hearing from you.
Best regards,

edsion January 21, 2020

Thank you for your help and suggestions 
Best regards

Please login or Register to Submit Answer