How to give a specific name of expert to excel

I have a jquerry function to make expert to excel and it is working also but when i download it saved in a name like Download,Download(1) as on. But i want to give a specific name of it as consolidated report

Bellow is my code:

Sys.Application.add_load(function () {

$('[id*=img_export]').on('click', function () {

ExportToExcel('grdConsolidated');

location.reload();

});

function ExportToExcel(Id) {

var msg = $('[id*=lblmsg]').text();

// alert(msg);

var tab_text = "";

var textRange;

var j = 0;

tab = document.getElementById(Id);

var headerRow = $('[id*=grdConsolidated] tr:first');

tab_text += headerRow.html() + '

var rows = $('[id*=grdConsolidated] tr:not(:has(th))');

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

if ($(rows[j]).css('display') != 'none') {

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

}

tab_text = tab_text + "

" + msg + "

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 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, Id + "ConsolidatedReport.xls");

}

else { //other browser not tested on IE 11

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

}

return (sa);

}

2 Replies

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

Sonasri Tripathy9y ago
hi. Thank you sir. but one problem is there if i m using this code then i missed background color of the header. So tell me what i shoud do so that i can use both specific file name and header background color also.
+1
Shakti Singh Dulawat9y ago
here is an example which demonstrates Export HTML Table to Excel With Custom File Name: http://www.kubilayerdogan.net/javascript-export-html-table-to-excel-with-custom-file-name/
+1