skip to Main Content

Export all rows from DataTables in excel but exported only visible rows, but i am try to export all rows that visible or hidden in the pagination – Javascript

$(document).ready(function() { $('#downloadBtn').click(function() { var table = $('.table2excel').DataTable(); var allRows = table.rows().data().toArray(); var allRowsTable = $('<table>').append($('.table2excel').find('thead').clone()).append($('<tbody>')); for (var i = 0; i < allRows.length; i++) { allRowsTable.append($('<tr>').append(allRows[i])); } allRowsTable.table2excel({ filename: 'data.xls', sheetName: 'Sheet1', exclude: '.noExl', preserveColors: true }); }); });…

VIEW QUESTION
Back To Top
Search