DataTables - Export Excel

DataTables - Export Excel

PatrickOfreneoPatrickOfreneo Posts: 5Questions: 3Answers: 0

Hi guys, how can I export with large amount of data. The table that I'm using has 300,000 rows of data and when I try to export, it gives me this error.

What should i add in my code below in order to download large amount of data?

Thank you!


$('#product-list').DataTable({ "pageLength" : 10, "deferRender": true, "processing": true, dom: 'Bfrtip', 'buttons': [ { extend: "excelHtml5", title: '', text: "Download Excel", className: "btn btn-md btn-success btn-track1", } ], "ajax": { url : "<?php echo base_url(); ?>Users/get_user", type : 'GET' }, "aoColumns": [ { "data": "LastName" }, { "data": "FirstName" }, { "data": "Gender" }, { "data": "Address" }, { "data": "City" }, { "data": "Age" } ] });

This question has an accepted answers - jump to answer

Answers

  • colincolin Posts: 15,118Questions: 1Answers: 2,583
    Answer ✓

    Yep, I'm not surprised, that's putting a heavy load on the browser. We have a future project, probably next year, which will do server-side exports which would prevent this happening, but I don't think there's much you can do currently, I'm afraid, browsers just aren't designed for that kind of load.

    Colin

This discussion has been closed.