I have a button in my home page that exports the displayed tabular data in the page. Today I added some values in the table and the export button stopped working. It no longer downloads the data as .csv file. All the data of my web application is stored in mysql database. Below is the code I used for exporting.
function fnExcelReport() {
var tab_text = "<table border='2px'>";
var textRange; var j = 0;
tab = document.getElementById('archive'); // id of table
for (j = 0; j < tab.rows.length; j++) {
if (tab.rows[j].style.display == "none") {
continue;
}
tab_text = tab_text + tab.rows[j].innerHTML + "</tr>";
//tab_text=tab_text+"</tr>";
}
tab_text = tab_text + "</table>";
tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table
tab_text = tab_text.replace(/<input[^>]*>|<\/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 Summit.xls");
}
else //other browser not tested on IE 11
sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
return (sa);
I have tried deleting items in the database but after I reach the certain amount and input new item the exporting stops working. When I click export button it opens a new tab and the url says about:blank#blocked kindly help.