Get Free Trial

Excel Export data into multiple sheets in same File

Ravi Kumar asked on November 21, 2020

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.

1 answer

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,

Please login or Register to Submit Answer