asked on March 9, 2021
Hi I have four pivot tables in different tabs on same view
Is there any way i can export all the four pivot grid data to a single excel file
I know that we have an option to export each pivot grid seperately this is more of lind of bulk export
⋅ March 10, 2021
Hi Ranjith,
Thank you for posting your question.
By default, each Flexmonster instance exports the data to a separate file.
You could, however, export the data from each Flexmonster instance as a Uint8Array and combine it into a single .xlsx file with the help of external libraries.
In this case, the export would look similar to the following:
flexmonster.exportTo("excel", {
destinationType: "plain"
}, (res) => {
// do something with res
});
Note that when using the plain destination value, the callbackHandler needs to be defined as well in order to retrieve and process the resulting Uint8Array.
More on this here: https://www.flexmonster.com/api/exportto/.
Please let us know if this helps.
Best regards,
Mykhailo