How to Export the jQuery Datatable data to excel in mvc4?

Hello Everyone,

How to Export the jQuery Datatable data to excel in mvc4.

Now it is exporting 1st page only I want all data export to excel in one button export.

function fnExcelReportSecond() {

var tab_text = "";

var textRange; var j = 0;

tab = document.getElementById('ListDiv');

for (j = 0 ; j < tab.rows.length ; j++) {

tab_text = tab_text + tab.rows[j].innerHTML + "

}

var currentURL = window.location.origin;

var pth = currentURL + "/Pic/exportimg.jpg";

tab_text = tab_text + "

tab_text = tab_text + "";

tab_text = tab_text.replace(/]*>|<\/A>/g, "");//remove if u want links in your table

tab_text = tab_text.replace(/]*>|<\/input>/gi, ""); // reomves input params

var ua = window.navigator.userAgent;

var msie = ua.indexOf("MSIE ");

if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer

{

txtArea1.document.open("txt/html", "replace");

txtArea1.document.write(tab_text);

txtArea1.document.close();

txtArea1.focus();

sa = txtArea1.document.execCommand("SaveAs", true, "Say Thanks to Sumit.xls");

}

else

sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));

return (sa);

}

$("#btn_exportlistsecond").click(function () {

fnExcelReportSecond();

})

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhilash J A10y ago
Hi,
Thank you for all reply me.
This is the jquery datatable that have more than 1000 data with pagination. But now exporting only 50 record or data while display the datatable. How can I export complete data in button click. Kindly answer me.
0
Vinay Singh10y ago
Hi
try the below link
http://www.codeproject.com/Questions/759013/How-to-export-the-jquery-datatable-data-to-excel
0
Manas Mohapatra10y ago
Follow below links:

http://www.jquerybyexample.net/2012/10/export-table-data-to-excel-using-jquery.html

http://wsnippets.com/export-html-table-data-excel-sheet-using-jquery/
0