Export the HTML table to excel is not working in IE

by

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("https://stackoverflow.com/questions/22709029/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/

More Related Contents:

  1. keep placeholder on focus in IE10
  2. Run custom code after jQuery has been loaded via Modernizr
  3. Get jQuery version from inspecting the jQuery object
  4. Each for object? [duplicate]
  5. Google chart redraw/scale on window resize
  6. Enable & Disable a Div and its elements in Javascript [duplicate]
  7. Stripe Payment: Getting Error as Customer cus_***** does not have a linked card with ID tok_*****
  8. Jquery/JS prevent right click menu in browsers
  9. How do I move focus to next input with jQuery?
  10. Scrolling Overflowed DIVs with JavaScript
  11. Nested JSON: How to add (push) new items to an object?
  12. Max characters in textarea with jquery
  13. Delay Removing a Class in Jquery [duplicate]
  14. Navigate through list using arrow keys? (JavaScript/JQ)
  15. Determining if mouse click happened in left or right half of DIV
  16. Using delay with HTML or text setting doesn’t work
  17. Not able to launch a pdf file in inappbrowser in android
  18. JavaScript or jQuery equivalent of PHP’s strstr() function
  19. Convert string to sentence case in javascript
  20. Immediately-Invoked Function Expression (IIFE) In JavaScript – Passing jQuery
  21. Cross-site AJAX using jQuery
  22. Multiple rows with jcarousel
  23. How to parse 20 digit number using JavaScript and jQuery
  24. jQuery .val change doesn’t change input value
  25. How to capture browser close event?
  26. open a custom popup on browser window/tab close
  27. Remove selected file(s) before upload with Javascript
  28. Crop image white space automatically using jQuery
  29. document.documentElement.scrollTop return value differs in Chrome
  30. customize highcharts tooltip to show datetime

Leave a Comment