DataTables - Export Excel

PatrickOfreneo

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" }                                      
           
            ]
       
    });

colin

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