title: How to export Datatables table to Excel which works in IE as well
body: <p>I am using </p>
  
  <pre><code>  var tableToExcel = (function() {
          var uri = 'data:application/vnd.ms-excel;base64,'
          , template = '&lt;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"&gt;&lt;head&gt;&lt;!--[if gte mso 9]&gt;&lt;xml&gt;&lt;x:ExcelWorkbook&gt;&lt;x:ExcelWorksheets&gt;&lt;x:ExcelWorksheet&gt;&lt;x:Name&gt;{worksheet}&lt;/x:Name&gt;&lt;x:WorksheetOptions&gt;&lt;x:DisplayGridlines/&gt;&lt;/x:WorksheetOptions&gt;&lt;/x:ExcelWorksheet&gt;&lt;/x:ExcelWorksheets&gt;&lt;/x:ExcelWorkbook&gt;&lt;/xml&gt;&lt;![endif]--&gt;&lt;meta http-equiv="content-type" content="text/plain; charset=UTF-8"/&gt;&lt;/head&gt;&lt;body&gt;&lt;table&gt;{table}&lt;/table&gt;&lt;/body&gt;&lt;/html&gt;'
          , 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, fileName) {
              if (!table.nodeType) table = document.getElementById(table)
              var ctx = {
                  worksheet: fileName || 'Worksheet', 
                  table: table.innerHTML
              }
              $("&lt;a id='dlink'  style='display:none;'&gt;&lt;/a&gt;").appendTo("body");
                  document.getElementById("dlink").href = uri + base64(format(template, ctx))
                  document.getElementById("dlink").download = fileName;
                  document.getElementById("dlink").click();
          }
      })();
  </code></pre>
  
  <p>for exporting datatables to excel and it works fine in both chrome and firefox. however it gives </p>
  
  <blockquote>
    <p><strong>The data area passed to a system call is too small.</strong></p>
  </blockquote>
  
  <p>error in <strong>all IE versions</strong>. Please give me some workaround as how to solve this problem or suggest any new method that works in all browsers. I am googling about the same since yesterday but all in vain...
  Any help would be apperciated .. thanks</p>
  
  <p>:Edit i have tried downloadify.js, filesaver but didn't worked for me .</p>