Datatable excel export taking too long

Datatable excel export taking too long

chenschens Posts: 4Questions: 3Answers: 0

I'm using Datatables for some time now and i recently noticed that the export to CSV file for large entries is very slow.
When trying to export 500 to 1000 rows it can take about 10-20 seconds and 1000+ even more than 1 minute.

Maybe i'm not using it properly or there is a way to fix this situation?

I'm using dataTables_fh.min.js with the included libraries:
JSZip 2.5.0, pdfmake 0.1.18, DataTables 1.10.13, Buttons 1.2.4, HTML5 export 1.2.4, Print view 1.2.4, FixedHeader 3.1.2, Responsive 2.1.0

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,667Questions: 1Answers: 10,096 Site admin
    Answer ✓

    Can you update to DataTables 1.10.15 and Buttons 1.3.1 please? There are improvements in them that should significantly improve performance for export.

    Allan

  • chenschens Posts: 4Questions: 3Answers: 0

    Now its working great, thanks.

This discussion has been closed.