Split Excel Export into multiple excel sheets every 10k rows.

Split Excel Export into multiple excel sheets every 10k rows.

chsxechsxe Posts: 8Questions: 3Answers: 0

Hi,

When exporting a datatable with 50k - 100k rows in it and when deferRender: true... the page becomes unresponsive across all browsers. There are many discussions regarding this issue, however I haven't seen a solution that would be best suited for the case of 50-100k rows. I am not using serverside.

Is there a way I can split the export into a new excel sheet to download every 10k rows using javascript?

I have the latest version of datatables.

Thanks,
CH

Answers

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    Hi @chsxe ,

    I don't know of a way of doing it per sheet, but one option would be to combine the export with Select, see this example here. You could have buttons that select records in certain ranges with rows().select(), then only expect those. That would be individual workbooks but may give you a working solution perhaps.

    Hope that helps,

    Cheers,

    Colin

This discussion has been closed.