导出table表格

最新推荐文章于 2024-03-15 17:43:02 发布

Gckkoo

最新推荐文章于 2024-03-15 17:43:02 发布

阅读量520

点赞数 1

文章标签： table导出

本文链接：https://blog.csdn.net/gckkoo/article/details/81187989

版权

导出table表格

html

<table id="table" border="1" cellspacing="0">
    <thead>
    <tr>
        <th>姓名</th>
        <th>性别</th>
        <th>年龄</th>
    </tr>
    </thead>
    <tbody>
    <tr>
        <td>王源</td>
        <td>男</td>
        <td>17</td>
    </tr>
    <tr>
        <td>王俊凯</td>
        <td>男</td>
        <td>18</td>
    </tr>
    <tr>
        <td>易烊千玺</td>
        <td>男</td>
        <td>17</td>
    </tr>
    <tr>
        <td>TFBOYS</td>
        <td>男团</td>
        <td>5</td>
    </tr>
    </tbody>
 </table>
 <p onclick="btn('table')">导出</p>

script

var idTmr;
function getExplorer() {
    var explorer = window.navigator.userAgent ;
    if (explorer.indexOf("MSIE") >= 0) {//ie
        return 'ie';
    } else if (explorer.indexOf("Firefox") >= 0) {//firefox
        return 'Firefox';
    } else if(explorer.indexOf("Chrome") >= 0){//Chrome
        return 'Chrome';
    } else if(explorer.indexOf("Opera") >= 0){//Opera
        return 'Opera';
    } else if(explorer.indexOf("Safari") >= 0){//Safari
        return 'Safari';
    }
}
function btn(tableid) {
    if(getExplorer()=='ie') {
        var curTbl = document.getElementById(tableid);
        var oXL = new ActiveXObject("Excel.Application");
        var oWB = oXL.Workbooks.Add();
        var xlsheet = oWB.Worksheets(1);
        var sel = document.body.createTextRange();
        sel.moveToElementText(curTbl);
        sel.select();
        sel.execCommand("Copy");
        xlsheet.Paste();
        oXL.Visible = true;
        try {
            var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
        } catch (e) {
            print("Nested catch caught " + e);
        } finally {
            oWB.SaveAs(fname);
            oWB.Close(savechanges = false);
            oXL.Quit();
            oXL = null;
            idTmr = window.setInterval("Cleanup();", 1);
        }
    } else {
        tableToExcel(tableid)
    }
}
function Cleanup() {
    window.clearInterval(idTmr);
    CollectGarbage();
}
var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;base64,',
        template = '<html><head><meta 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));
    }

})();

Gckkoo

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
导出table表格

导出table表格html&lt;table id="table" border="1" cellspacing="0"&gt; &lt;thead&gt; &lt;tr&gt; &lt;th&gt;姓名&lt;/th&gt; &lt;th&gt;性别&lt;/th&gt;
复制链接

扫一扫