Encoding UTF-8 when exporting HTML table to Excel

by

First: Your header is malformed. It should be:

<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">

And second: It should be into your template, because it contains charset information for Excel.

<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"><meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8"><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))
          }
        })()
</script>

More Related Contents:

  1. Using Javascript’s atob to decode base64 doesn’t properly decode utf-8 strings
  2. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  3. HTML Table to Excel Javascript
  4. Is it possible to use any HTML5 fanciness to export local storage to Excel?
  5. Excel VBA: Get inner text of HTML table td
  6. How do I export multiple html tables to excel?
  7. Copy/Paste from Excel to a web page
  8. How to change all elements with the same IDs javascript/html? [duplicate]
  9. Preserve browser window aspect ratio while shrinking [closed]
  10. Change from (+) symbol to (-) after click (function(){
  11. Detecting input change in jQuery?
  12. HTML5 record audio to file
  13. HTML5 Canvas toDataURL returns blank
  14. How to draw an inline svg (in DOM) to a canvas?
  15. How to convert Base64 String to javascript file object like as from file input form?
  16. Changing element style attribute dynamically using JavaScript
  17. How to get browser width using JavaScript code?
  18. Get video duration when input a video file
  19. How to detect a long touch pressure with javascript for android and iphone?
  20. How to break line in JavaScript?
  21. HTML Mobile -forcing the soft keyboard to hide
  22. how to change the background image of div using javascript?
  23. Decode HTML entities in JavaScript? [duplicate]
  24. How to move all HTML element children to another parent using JavaScript?
  25. How to scroll table’s “tbody” independent of “thead”?
  26. Detect input value change with MutationObserver
  27. HTML5 video javascript controls – restart video
  28. Trigger for span text/html on changed
  29. Returning value from confirmation dialog using JQuery UI dialog
  30. HTML5 Video autoplay with sound unmuted

Leave a Comment