前端js实现打印（导出）excel表格

最新推荐文章于 2024-02-21 22:34:40 发布

森林中的神光

最新推荐文章于 2024-02-21 22:34:40 发布

阅读量921

点赞数

本文链接：https://blog.csdn.net/qq_43685118/article/details/84035133

版权

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

产品原型：

图片.png

功能需求：点击导出考勤表格按钮，会自动下载成Excel格式

图片.png

jsp页面代码：

<div class="tools"><button type="button" class="btn green" id="excell"  onclick="method5('dataTable')">导出考勤表</button></div>

js代码

//打印表格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';        }    }    function method5(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  border="1">{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))        }    })()

完整的可复制黏贴的demo：

<!DOCTYPE html><html>    <head>        <meta charset="UTF-8">        <title></title>    </head>    <body>        <div class="tools">            <button type="button" class="btn green" id="excell" onclick="method5('dataTable')">导出考勤表格</button>        </div>        <table border="1" id="dataTable">            <tr>                <td>王婷111</td>                <td>一见倾城333 </td>            </tr>            <tr>                <td>祈澈姑娘222</td>                <td>Python开发者交流平台44</td>            </tr>            <tr>                <td>wwwangting888</td>                <td>13661725475</td>            </tr>        </table>    </body>    <script>        //打印表格        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';            }        }        function method5(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  border="1">{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></html>