Exporting large number of records to several sheets in one excel file

AyeshDilshan

Forums

Hi All,

I have a large number of transactions (around 5 million) and would like to export them to an Excel file. Since Excel has a limitation of nearly 1 million records per sheet, I need to export the records in chunks of 1 million into separate sheets manually.

Do any of you have a script that can save all the transactions into several sheets within the same Excel file, breaking the transactions into 1 million per sheet?

I look forward to your support.

Regards.