Get Free Trial

Export to Excel

Answered
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

Public
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: https://www.flexmonster.com/api/exportto/.
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer