Set filename of Excel sheet to export from html table

Abhijeet Deshmukh

11y16.7k.NET

I have one html table. Now I am exporting this table to Excel Sheet

using Javascript. When this excel sheet is getting downloaded,the

filename is like "download.xls". Now I want filename as current_date

instead of "download"...Below is my javascript code:

function write_to_excel() {

var tab_text = "";

var textRange; var j = 0;

tab = document.getElementById('tt1'); // id of table

tab1 = document.getElementById('testTable'); // id of table

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

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

//tab_text=tab_text+"";

}

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

tab_text = tab_text + tab1.rows[j].innerHTML + "";

//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(/]*>/gi, ""); // remove if u want images in your table

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

//var a = document.createElement('a');

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 //other browser not tested on IE 11

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

return (sa);

}

3 Replies

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

Amitesh Verma11y ago
function toExcel(){
var tab_text="";
var tab_text=tab_text+"";
var tab_text=tab_text+"";
var tab_text=tab_text+"";
var textRange; var j=0;
tab = document.getElementById('table_results'); // id of table

for(j = 0 ; j < tab.rows.length ; j++)
{
tab_text=tab_text+tab.rows[j].innerHTML+"";
}

tab_text=tab_text+"
";
tab_text= tab_text.replace(/]*>|<\/A>/g, "");
tab_text= tab_text.replace(/]*>/gi,"");
tab_text= tab_text.replace(/]*>|<\/input>/gi, "");
tab_text= tab_text.replace(/]*>|<\/button>/gi, "");

var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");

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

return (sa);
}
Abhijeet Deshmukh11y ago
Thanks Amitesh for ur response.But,where to put this line in above code?
Amitesh Verma11y ago
Response.AddHeader("Content-Disposition", "inline;filename=filename.xls")