Skip to content Skip to sidebar Skip to footer
Home / Export To Excel / Html Table / Javascript

Export Multiple Html Tables To Excel With Javascript Function

Post a Comment
I'm trying to export several tables from HTML code to excel, I found a function here on Stack Overflow, and it works perfectly with one table, but I'm trying to made the change so

Solution 1:

at the end i did it like this:

functiontableToExcel(name) {
        var tables=[];
        r('div[id^="reportesTablaExcel"]').each(function(){
            tables.push(r(this).attr('id'));
        });

        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) { returnwindow.btoa(unescape(encodeURIComponent(s))) }
        , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
        var i;
        completeTables=[];
        for (i = 0; i < tables.length; ++i) {
            var table = tables[i];
            completeTables.push(r("#reportesTablaExcel"+i).html());
        }
        if (!table.nodeType) table = table
            var ctx = {worksheet: name || 'Worksheet', table: completeTables}
            window.location.href = uri + base64(format(template, ctx))

    returnwindow.location.href;
}

Solution 2: 

tablesToExcel(e){
        var tab_text = document.getElementById("MsoNormalTable").outerHTML+document.getElementById("MsoNormalTable2").outerHTML;
        var textRange; var j = 0;
        var sa;

        var ua = window.navigator.userAgent;
        var msie = ua.indexOf("MSIE ");
        var txt = document.getElementById('txtArea1').contentWindow;
        if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
        {
            txt.document.open("txt/html", "replace");
            txt.document.write(tab_text);
            txt.document.close();
            txt.focus();
            sa = txt.document.execCommand("SaveAs", true, "Say Thanks to Sumit.xls");
        }
        else   
            sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
        return (sa);
    }


<table id="MsoNormalTable">
        <tr><th>sampleT1</th><th>sampleT1</th><th>sampleT1</th></tr><tr><td>sampleV1</td><td>sampleV1</td><td>sampleV1</td></tr>
    </table>
    <tableid="MsoNormalTable2"><tr><th>sampleT2</th><th>sampleT2</th><th>sampleT2</th></tr><tr><td>sampleV2</td><td>sampleV2</td><td>sampleV2</td></tr></table><buttononClick={this.tablesToExcel.bind(this)}className="btn btn-primary"><iclassName="fa fa-download"></i> Export all to excel</button><iframeid="txtArea1"className="displayNo"></iframe>

Post a Comment for "Export Multiple Html Tables To Excel With Javascript Function"