Skip to main content

Export html table to csv using javascript

<table>
    <tr><th>Name</th><th>Age</th><th>Country</th></tr>
    <tr><td>MANOJ</td><td>26</td><td>INDIA</td></tr>
    <tr><td>KRISHAN</td><td>19</td><td>INDIA</td></tr>
    <tr><td>SUSHEEL</td><td>32</td><td>INDIA</td></tr>
</table>
<button onclick="Export_CSV ()">Export HTML table to CSV file</button>

function download_csv(csv, filename) {
    var csvFile;
    var downloadLink;

    csvFile = new Blob([csv], {type: "text/csv"});
    downloadLink = document.createElement("a");
    downloadLink.download = filename;
    downloadLink.href = window.URL.createObjectURL(csvFile);
    downloadLink.style.display = "none";
    document.body.appendChild(downloadLink);
    downloadLink.click();
}

function export_table_to_csv(html, filename) {
    var csv = [];
    var rows = document.querySelectorAll("table tr");
  
    for (var i = 0; i < rows.length; i++) {
        var row = [], cols = rows[i].querySelectorAll("td, th");
      
        for (var j = 0; j < cols.length; j++)
            row.push(cols[j].innerText);
      
        csv.push(row.join(","));      
    }

    // Download CSV
    download_csv(csv.join("\n"), filename);
}

function Export_CSV {
    var html = document.querySelector("table").outerHTML;
    export_table_to_csv(html, "table.csv");
}

Comments

Popular posts from this blog

Difference between SQL Function and Stored Procedure

The main difference between functions and stored procedures  are given bellow: Function(User Defined) It returns only one value We can’t use transaction in function Only have input parameter We can’t called SP from function We can’t use exception handling using Try-Catch block in function We can use function in select/where/having statement Stored Procedure (Store Procedure) It returns zero, single or multiple values We can use transaction in SP Can have input/output parameter We can called function from SP We can use exception handling using Try-Catch block in SP We can’t use SP in select/where/having statement