Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

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

Answered
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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 20, 2020

Hello,
 
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,
Illia

Public
edsion January 21, 2020

Hello,
Thank you for your help and suggestions 
 
Best regards

Please login or Register to Submit Answer