Breaking News: Grepper is joining You.com. Read the official announcement!

html table to excel javascript

Add Answer

Ranish Patel answered on July 1, 2020 Popularity 10/10 Helpfulness 5/10

answer html table to excel javascript

related Export html table data to Excel using JavaScript

related table to excel javascript

related export table to excel javascript

related javascript table to excel

html table to excel javascript

Comment

<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>

Popularity 10/10 Helpfulness 5/10 Language javascript

Source: Grepper

Tags: excel html-table javascript

Link to this answer
Share Copy Link

Contributed on Jul 01 2020

Ranish Patel

0 Answers Avg Quality 2/10

Closely Related Answers

Export html table data to Excel using JavaScript

Comment

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

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Feb 01 2022

Tender Tamarin

0 Answers Avg Quality 2/10

table to excel javascript

Comment

<script
    src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
<script
    src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>

Popularity 8/10 Helpfulness 2/10 Language javascript

Source: phppot.com

Tags: excel javascript jav

Link to this answer
Share Copy Link

Contributed on Oct 04 2022

tony kungu

0 Answers Avg Quality 2/10

export table to excel javascript

Comment

function exportTableToExcel(tableId, filename = 'table') {
  let downloadLink;
  const dataType = 'application/vnd.ms-excel';
  const table = document.getElementById(tableId);
  const tableHTML = table.outerHTML.replace(/ /g, '%20');

  // Create download link element
  downloadLink = document.createElement('a');
  document.body.appendChild(downloadLink);

  if (navigator.msSaveOrOpenBlob) {
    const blob = new Blob(['\ufeff', tableHTML], {
      type: dataType
    });
    navigator.msSaveOrOpenBlob(blob, `${filename}.xls`);
  } else {
    // Create a link to the file
    downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

    // Setting the file name
    downloadLink.download = `${filename}.xls`;

    // Simulating click to trigger the download
    downloadLink.click();
  }
  
  document.body.removeChild(downloadLink);
}

// Usage: Call the exportTableToExcel function with the table id as the first argument
exportTableToExcel('myTable', 'table_filename');

Popularity 7/10 Helpfulness 2/10 Language javascript

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

javascript table to excel

Comment

let tableToExcel = (function() {
    let uri = 'data:application/vnd.ms-excel;base64,',
        infoExcelBase64 = 'PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+PHg6RXhjZWxXb3JrYm9vaz48eDpFeGNlbFdvcmtzaGVldHM+PHg6RXhjZWxXb3Jrc2hlZXQ+PHg6TmFtZT57d29ya3NoZWV0fTwveDpOYW1lPjx4OldvcmtzaGVldE9wdGlvbnM+PHg6RGlzcGxheUdyaWRsaW5lcy8+PC94OldvcmtzaGVldE9wdGlvbnM+PC94OkV4Y2VsV29ya3NoZWV0PjwveDpFeGNlbFdvcmtzaGVldHM+PC94OkV4Y2VsV29ya2Jvb2s+PC94bWw+PCFbZW5kaWZdLS0+',
        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>' +
        atob(infoExcelBase64) +
        '<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];
            })
        }
    // console.log(template)
    return function(table, name) {
        if (!table.nodeType) table = document.getElementById(table)
        let ctx = {
            worksheet: name || 'Worksheet',
            table: table.innerHTML
        }
        // window.location.href = uri + base64(format(template, ctx))
        let a = document.createElement('a');
        a.href = uri + base64(format(template, ctx));
        a.download = name + '.xls';
        a.click();
    }
})();
$("#excelDownload").click(function() {
    tableToExcel('tblToExcl', 'Sheet Name');
});

Popularity 7/10 Helpfulness 2/10 Language javascript

Source: Grepper

Tags: excel javascript

Link to this answer
Share Copy Link

Contributed on Mar 23 2023

Shadow

0 Answers Avg Quality 2/10

html table to excel javascript

Contents

More Related Answers

html table to excel javascript

Closely Related Answers

Export html table data to Excel using JavaScript

table to excel javascript

export table to excel javascript

javascript table to excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.