Export HTML table to Excel its downloading table contents to the Excel

Question

I'm Using This Function while download i need to give default name current date but it's giving default name as download i need to change the name how i can change?

var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;
    base64,', template = '<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c)
    { 
      return s.replace(/{(\w+)}/g, function(m, p) { return c[p];  
    }) 
  }

  return function(table, name) {

     if (!table.nodeType) table = document.getElementById(table)

     var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}

    window.location.href = uri + base64(format(template, ctx))
 }

})()

Community · Accepted Answer · 2017-05-23 11:53:39Z

4

Working Demo

Based on this answer you have to do the following:

*-Add a hidden link to your html in order to use the download attribute supported by modern browsers:

<a id="dlink"  style="display:none;"></a>

*-Add a third parameter specifying the file name for the function caller, here we will call the file 'myfile.xls':

<input type="button" onclick="tableToExcel('tablename', 'name', 'myfile.xls')" value="Export to Excel">

*-Add the third parameter to the function deceleration:

 return function (table, name, filename)

*-Remove the following line, we are no longer biding the download to window location href directly.

 window.location.href = uri + base64(format(template, ctx))

*-Add the following 3 lines to replace the removed line, we will assign the download to the hidden link we added to the html, then we will bid that link to the browser default download function which allows filename attribute:

            document.getElementById("dlink").href = uri + base64(format(template, ctx));
            document.getElementById("dlink").download = filename;
            document.getElementById("dlink").click();

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Mar 6, 2014 at 2:59

Mohammed Joraid

6,5802 gold badges29 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohammed Joraid Over a year ago

@AakashGoplani Well, I wrote that answer in 2014 so I'm not sure what has changed in browsers technology since that time. I just tested the fiddle on Mozilla Firefox, Microsoft Edge, and Google Chrome. Chrome and Firefox were successful, Edge failed to even prompt to download, the cursor kept circling indicating loading but no action happened.

Collectives™ on Stack Overflow

Export HTML table to Excel its downloading table contents to the Excel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related