How to change the name of file while exporting data to Excel?

Not only for excel, in addition, for many kind of format can useable.

 var element = document.createElement('a'); element.setAttribute('href', 'data:application/vnd.ms-excel,' + encodeURIComponent(htmlTable)); element.setAttribute('download', fileName); element.style.display = 'none'; document.body.appendChild(element); element.click(); document.body.removeChild(element); 

https://ourcodeworld.com/articles/read/189/how-to-create-a-file-and-generate-a-download-with-javascript-in-the-browser-without-a-server

I had the same issue, and since the new format (maybe not supported by every browser) <a download=""></a> the following worked fine for me. This use directly HTML/Javascript without the PHP server part, because using a submit form is too heavy for big data tables.

• changing <button> to <a>
• no more window.open()
• using the basic <a> behavior (so, no more e.preventDefault()) but changing href to data:blabla and adding download="filename" :

<div id="example" class="k-content"> <a href="#" id="btnExport" >Export to csv!</a> <div id="grid"></div> </div> <script> $("#btnExport").click(function (e) { var result = "data:application/vnd.ms-excel,"; this.href = result; this.download = "my-custom-filename.xls"; return true; }); </script> 

You can't do this with client-side JavaScript, you need to set the response header...

.NET

Response.AddHeader("Content-Disposition", "inline;filename=filename.xls") 

Or PHP

$filename = 'somehting.xls'; header('Content-Disposition: attachment; filename="'.$filename.'"'); 

Response.AddHeader "Content-Disposition", "attachment; filename=C:\YOURFILENAME.xls;" 

var a = document.createElement('a'); //getting data from our div that contains the HTML table var data_type = 'data:application/vnd.ms-excel'; a.href = data_type + ', ' + encodeURIComponent(tab_text); //setting the file name a.download = 'SupervisorReport.xls'; //triggering the function a.click(); //just in case, prevent default behaviour e.preventDefault(); return (a);