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
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.
Thank you for your help and suggestions