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

List Controls: List Box and Drop Downlist

ASP.Net provides the controls: drop-down list, list box, radio button list, check box list and bulleted list. These control let a user choose from one or more items from the list. List boxes and drop-down list contain one or more list items. These lists could be loaded either by code or by the ListItem Collection Editor. Basic syntax for list box control: <asp:ListBox ID="ListBox1"        runat="server"        AutoPostBack="True"        OnSelectedIndexChanged="ListBox1_SelectedIndexChanged"> </asp:ListBox> Basic syntax for a drop-down list control: <asp:DropDownList ID="DropDownList1"       runat="server"       AutoPostBack="True"       OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> </asp:DropDownList>

Sql CharIndex Function

The CHARINDEX  function returns the starting position of the specified expression in a character string. Example: Search for "t" in string "DotNetReceipe", and return position: SELECT CHARINDEX( 't' , 'DotNetReceipe' ) AS Position;