Javascript to export html table to Excel

by

If you add:

<meta http-equiv="content-type" content="text/plain; charset=UTF-8"/>

in the head of the document it will start working as expected:

<script type="text/javascript">
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]--><meta http-equiv="content-type" content="text/plain; charset=UTF-8"/></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))
  }
})()
</script>

Updated Fiddle Here.

More Related Contents:

  1. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  2. HTML Table to Excel Javascript
  3. How can I export Excel files using JavaScript? [closed]
  4. Converting Excel Date Serial Number to Date using Javascript
  5. Export to xls using angularjs
  6. How can I lock the first row and first column of a table when scrolling, possibly using JavaScript and CSS?
  7. Is it possible to use any HTML5 fanciness to export local storage to Excel?
  8. Encoding UTF-8 when exporting HTML table to Excel
  9. Click button or execute JavaScript function with VBA
  10. Parse XLSX with Node and create json
  11. Excel VBA: Get inner text of HTML table td
  12. How do I export multiple html tables to excel?
  13. Copy/Paste from Excel to a web page
  14. How to export an HTML table as a .xlsx file
  15. How to read an excel file contents on client side?
  16. Managing jQuery plugin dependency in webpack
  17. How to watch for a route change in AngularJS?
  18. How to stop all timeouts and intervals using javascript? [duplicate]
  19. How to access HTML element without ID?
  20. In Javascript, is it expensive to use try-catch blocks even if an exception is never thrown?
  21. Avoiding problems with JavaScript’s weird decimal calculations
  22. javascript function inArray
  23. Better way to prevent browser caching of JavaScript files
  24. Set undefined javascript property before read
  25. When would someone need to create a deferred?
  26. Firebase retrieve child keys but not values
  27. How do you make images load lazily only when they are in the viewport?
  28. JavaScript dependency management: npm vs. bower vs. volo [closed]
  29. ES6 import from root
  30. Generate Random Color distinguishable to Humans

Leave a Comment