Export the HTML table to excel is not working in IE

export html table to excel using jquery in ie
export html table to excel using javascript
export large html table to excel using javascript
jquery plugin for excel export
table to excel jquery github
table2excel is not a function
table2excel jquery with css
json to xlsx javascript

Exporting HTML table to Excel is working fine in Chrome and Firefox but it is not working in Internet Explorer 10.

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))
  }
})()

Excel Export Script works on IE7+ Mozilla & Chrome ===========================================================

function fnExcelReport()
{
  var tab_text="<table border='2px'><tr bgcolor='#87AFC6'>";
  var textRange; var j=0;
  tab = document.getElementById('headerTable'); // id of table


  for(j = 0 ; j < tab.rows.length ; j++)
  {
    tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
    //tab_text=tab_text+"</tr>";
  }

  tab_text=tab_text+"</table>";
  tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
  tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
  tab_text= tab_text.replace(/<input[^>]*>|<\/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,"Say Thanks to Sumit.xls");
  }
  else                 //other browser not tested on IE 11
  sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));


  return (sa);
}

Just Create a blank iframe

<iframe id="txtArea1" style="display:none"></iframe>

Call this function on

<button id="btnExport" onclick="fnExcelReport();"> EXPORT </button>

JSFiddle (Note only tested in IE 10): http://jsfiddle.net/x0av0ax5/1/

Code not working in IE : Export to excel, Once i click on button, it should export the the table data to a excel sheet. I have been provided with a code which is working for Chrome but not  Hi i use this code to make an export on my HTML table to excel, but it not working in IE 11. Q&A for Work. Stack Overflow for Teams is a private, secure spot for

Please see this plugin which uses BLOB. https://github.com/rainabba/jquery-table2excel

if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
{
  if (typeof Blob !== "undefined") {
    //use blobs if we can
    tab_text = [tab_text];
    //convert to array
    var blob1 = new Blob(tab_text, {
      type: "text/html"
    });
    window.navigator.msSaveBlob(blob1, "download.xls");
  } else {
    txtArea1.document.open("txt/html", "replace");
    txtArea1.document.write(tab_text);
    txtArea1.document.close();
    txtArea1.focus();
    sa = txtArea1.document.execCommand("SaveAs", true, "download.xls");
    return (sa);
  }
} 

else
  window.location.href = 'data:application/vnd.ms-excel,' + encodeURIComponent(tab_text);

[Solved] Export to Excel not working in IE, I have some code taken from a forum that exports a table from html page and exports into Excel, however it doesn't work in IE but does in  Uchit,thank you.Yes the code is working. Problem is I was using Libre Office,so in Chrome export to excel was not working fine (ref screen shot in m question). But in MS office it working,as you have mentioned. Thank you for providing a jQuery code for this. – Sukane Mar 19 '14 at 17:35

data uri does not support IE, maybe you post your excel xml data to server to generate the file.

And you can use Downloadify (Flash) to generate the file.

https://github.com/dcneiner/Downloadify

Export html's table to excel doesn't work in IE?, I'm trying to export a html table to IE but it doesn't work and it doesn't play anything. I tested on Firefox and Chrome. It can export. here is the  I've been exporting a table from HTML to Excel using the very same code shown in this link and it worked pretty good in many browsers. The problem comes when I test it on the brand new MS Edge web browser, it opens up a new blank tab, just that.

Found a community version of SheetJS that works like a cham!

No warning like "The file format and extension of 'file.xls' don't match. This file could be corrupted or unsafe."

Import the library

    <script src="../Scripts/xlsx.full.min.js"></script>

Paste the function that calls the library

function doit(type, fn, dl) {
        var elt = document.getElementById('data-table');
        var wb = XLSX.utils.table_to_book(elt, { sheet: "Sheet JS" });
        return dl ?
            XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) :
            XLSX.writeFile(wb, fn || ('test.' + (type || 'xlsx')));
    }

Trigger the function using a button or anything that suit your needs.

<button id="btnExport" onclick="doit('xlsx');"> EXPORT </button>

Sample code can be found in this page

Export Html Table to Excel file is not working!, Hi guys I am trying to export an HTML table to Excel file! Are you saying it does not work in IE 9 , yet it works in some other browsers? Exporting HTML table to Excel is working fine in Chrome and Firefox but it is not working in Internet Explorer 10. Thanks for contributing an answer to Stack

https://social.technet.microsoft.com/Forums/office, Hi Team, i am using react-html-table-to-excel in my React js project to export html to Excel format . i entered this cmd line to install npm install  I found the following code online. But it doesn't work if i use "thead" and "tbody" tags. Javascript is browser side language, you can convert an HTML document to PDF using a server side language. Also note that ActiveXObject solution are not portable, it only works on IE. – Emre Yazici Jul 4 '11 at 2:34. The reason the solution you found on

ReactHTMLTableToExcel not Working in Internet Explorer · Issue #3 , Excel table compatibility issues. ; element The HTML element to render your table to. The limitation of this method is export to excel will work in IE because it​  hi, i want to export the html table data to csv file.this funtionality must work in IE,Chrome and fire fox browsers.I have seen few links in internet but those are working in other browsers except in IE.

Export dynamic html table to excel in javascript, Exporting HTML table to Excel is working fine in Chrome and Firefox but it is not working in Internet Explorer 10. I need to export the html table in my page to an Excel when user clicks 'Export' button. Now, I found a solution here on stack overflow that works in Firefox. Export dynamic html table to excel in javascript in firefox browser

Comments
  • Worked with version 11.0.9600.18124
  • It is working fine in IE 11. But after exporting, when I open the xls file, it shows a warning message saying: "The file format and extension does not match. The file could be corrupted or unsafe... do you want to open it anyway?" If I press yes the excel is opened perfectly. Could you have any clue to prevent the warning message ???
  • @Abdur Rahman: This warning is from excel application and it is because we are saving data in old excel format(tab separated). In case you wish have it in the latest excel format, you will have to write some kind of server code and attach the file to the response because no client side script works perfectly well for new encodings.
  • Thanks sampopes. If anyone find any client side script to prevent the warning please share it for others.
  • Firstly, there are example in GitHub, and please revise the question with any code you tried which are not working / error. Thanks