Export Table to Excel

by Marventus

HTML

<iframe id="txtArea1" style=""></iframe>
<h1>tableToExcel Demo</h1>
<p>Exporting the W3C Example Table</p>

<a id="export-button" href="javascript:void(0)">Export to Excel</a>

<table id="testTable" summary="Code page support in different versions of MS Windows." rules="groups" frame="hsides" border="2">
  <caption>CODE-PAGE SUPPORT IN MICROSOFT WINDOWS</caption>
  <colgroup align="center"></colgroup>
  <colgroup align="left"></colgroup>
  <colgroup span="2" align="center"></colgroup>
  <colgroup span="3" align="center"></colgroup>
  <thead valign="top">
    <tr>
      <th>Code-Page
        <br>ID</th>
      <th>Name</th>
      <th>ACP</th>
      <th>OEMCP</th>
      <th>Windows
        <br>NT 3.1</th>
      <th>Windows
        <br>NT 3.51</th>
      <th>Windows
        <br>95</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>1200</td>
      <td style="background-color: #00f; color: #fff">Unicode (BMP of ISO/IEC-10646)</td>
      <td></td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>*</td>
    </tr>
    <tr>
      <td>1250</td>
      <td style="font-weight: bold">Windows 3.1 Eastern European</td>
      <td>X</td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>X</td>
    </tr>
    <tr>
      <td>1251</td>
      <td>Windows 3.1 Cyrillic</td>
      <td>X</td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>X</td>
    </tr>
    <tr>
      <td>1252</td>
      <td>Windows 3.1 US (ANSI)</td>
      <td>X</td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>X</td>
    </tr>
    <tr>
      <td>1253</td>
      <td>Windows 3.1 Greek</td>
      <td>X</td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>X</td>
    </tr>
    <tr>
      <td>1254</td>
      <td>Windows 3.1 Turkish</td>
      <td>X</td>
      <td></td>
      <td>X</td>
      <td>X</td>
      <td>X</td>
    </tr>
    <tr>
      <td>1255</td>
      <td>Hebrew</td>
      <td>X</td>
      <td></td>
      <td></td>
      <td></td>
      <td>X</td>
  ...

JavaScript

function exportToExcel(tableID) {
  var htmls = "";
  var uri = 'data:application/vnd.ms-excel;base64,';
  var 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>';
  var base64 = function(s) {
    return window.btoa(unescape(encodeURIComponent(s)))
  };

  var format = function(s, c) {
    return s.replace(/{(\w+)}/g, function(m, p) {
      return c[p];
    })
  };

  htmls = "<table>" + document.getElementById(tableID).innerHTML + "</table>";

  var ctx = {
    worksheet: 'Worksheet',
    table: htmls
  };

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

  if (msie > -1 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
  {
    /*console.log(htmls);
    txtArea1.document.open("txt/html", "replace");
    txtArea1.document.write(format(template, ctx));
    txtArea1.document.close();
    txtArea1.focus();
    txtArea1.document.execCommand("SaveAs", true, "export.xls");*/
  } else {
    var link = document.createElement("a");
    link.download = "export.xls";
    link.href = uri + base64(format(template, ctx));
    link.click();
  }
}