Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
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