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.
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:
destinationType: "plain" in the parameters of
exportTo() API call: the Flexmonster’s contents will be exported as a Uint8Array and returned with
We assume this GitHub thread might be helpful for your case as well.
Our team hopes it works for you.