Get Free Trial

Export to Excel

Ranjith 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

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster 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:
Please let us know if this helps.
Best regards,

Please login or Register to Submit Answer