Exporting Data to Excel (1,000,000 + rows)
I have some end-users requesting the ability to export rows from a table in the webplayer to Excel. However, the amount of records they want to export is 1,000,000+ records.
I am aware that Excel has a row limit of 1,048,576. So the end-user needs the ability to export the table data to multiple excel sheets.
Would anyone know how to achieve this? Maybe an IronPython script that can export the data into multiple files which can then be imported to Excel?
Or some other workaround?
Would appreciate your assistance.