前台导出

最新推荐文章于 2024-06-13 02:15:28 发布

HELLO_FANDONGBING

最新推荐文章于 2024-06-13 02:15:28 发布

阅读量372

点赞数

文章标签：前段导出

本文链接：https://blog.csdn.net/qq_30443907/article/details/82592463

版权

纯前台导出

  <!DOCTYPE html>    
    <html>    
    <head lang="en">    
        <meta charset="UTF-8">    
        <title>html 表格导出</title>    
        <script language="JavaScript" type="text/javascript">    


            var idTmr;  
        //获取当前浏览器类型  
            function  getExplorer() {    
                var explorer = window.navigator.userAgent ;    
                //ie    
                if (explorer.indexOf("MSIE") >= 0) {    
                    return 'ie';    
                }    
                //firefox    
                else if (explorer.indexOf("Firefox") >= 0) {    
                    return 'Firefox';    
                }    
                //Chrome    
                else if(explorer.indexOf("Chrome") >= 0){    
                    return 'Chrome';    
                }    
                //Opera    
                else if(explorer.indexOf("Opera") >= 0){    
                    return 'Opera';    
                }    
                //Safari    
                else if(explorer.indexOf("Safari") >= 0){    
                    return 'Safari';    
                }    
            }    

        //获取到类型需要判断当前浏览器需要调用的方法，目前项目中火狐，谷歌，360没有问题  
            //win10自带的IE无法导出  
            function exportExcel(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();    
            }   

        //判断浏览器后调用的方法，把table的id传入即可  
            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))    
                }    
            })()    

        </script>    
    </head>    
    <body>   

    <div >    

        <button type="button" onclick="exportExcel('tableExcel')">导出Excel</button>    
    </div>    
    <div id="myDiv">    
    <table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">    
        <tr>    
            <td colspan="5" align="center">html 表格导出道Excel</td>    
        </tr>    
        <tr>    

            <td>列标题</td>    
        </tr>    
        <tr>    
            <td>aaa</td>    
            <td>bbb</td>    
            <td>ccc</td>    
            <td>ddd</td>    
            <td>eee</td>    
        </tr>    
        <tr>    
            <td>AAA</td>    
            <td>BBB</td>    
            <td>CCC</td>    
            <td>DDD</td>    
            <td>EEE</td>    
        </tr>    
        <tr>    
            <td>FFF</td>    
            <td>GGG</td>    
            <td>HHH</td>    
            <td>III</td>    
            <td>JJJ</td>    
        </tr>    
    </table>    
    </div>    
    </body>    
    </html>

HELLO_FANDONGBING

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
前台导出

纯前台导出 &lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head lang="en"&gt; &lt;meta charset="UTF-8"&gt; &lt;title&gt;html 表格导出&lt;/title&gt; &
复制链接

扫一扫