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

Excel Export data into multiple sheets in same File

Answered
Ravi Kumar asked on November 21, 2020

Hi,
Assume we have 1 lakh of data and we don’t want to export into single sheet of excel file, but we need to divide the data and export into multiple sheets in same file. Please find the below split up way.
1 Lakh data – Sheet 1(25,000), Sheet 2(25,000), Sheet 3(25,000), Sheet 4(25,000)
I have attached 2 files, one(Period Information) with 11 records in Sheet 1, another(Period Information – Multiple Sheets) with 5 records in Sheet1, 6 records in Sheet2.
Is there any possibility to export in the 2nd file format by splitting data into multiple sheets.
 
Regards,
Ravi
 

1 answer

Public
Milena Pechura Milena Pechura Flexmonster November 24, 2020

Hello, Ravi,
 
Thank you for your question.
 
We would like to inform you that our export functionality provides this logic: all pivot table content is exported into one Excel sheet.
 
To divide the data into multiple sheets, our team kindly suggests considering the following approach:
Please specify destinationType: "plain" in the parameters of exportTo() API call: the Flexmonster’s contents will be exported as a Uint8Array and returned with callbackHandler. Then split the array into sheets using the dedicated library. For example, the JavaScript library SheetJS
We assume this GitHub thread might be helpful for your case as well.
 
Our team hopes it works for you.
 
Kind regards,
Milena

Please login or Register to Submit Answer