• 前端JS脚本将网页表格导出为Excel


    话不多说,上代码!

    <!DOCTYPE>
    <html>
        <head>
            <title>Excel Test</title>
        </head>
        
        <body>
            <div style="100%;padding:40px;">
                Excel Test
            </div>
            <table id="excel">
                <tr>
                    <td>Name</td>
                    <td>Age</td>
                    <td>Gender</td>
                </tr>
                <tr>
                    <td>Young</td>
                    <td>24</td>
                    <td>Male</td>
                </tr>
                <tr>
                    <td>Even</td>
                    <td>23</td>
                    <td>Female</td>
                </tr>
                <tr>
                    <td>Leon</td>
                    <td>25</td>
                    <td>Male</td>
                </tr>
            </table>
        </body>
        <div style="200px;margin:auto;text-align:center;">
            <button onclick="ok()">导出</button>
        </div>
        
        <script>
        var ok = (function () {
            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]--></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) {
                var tables = document.getElementById('excel');
                var ctx = { worksheet: name || 'Worksheet', table: tables.innerHTML }
                window.location.href = uri + base64(format(template, ctx));
            }
        })();
    
        function ExportSupplierMonthlyData() {
            try {
                tableToExcel();
            } catch (err) {
                bootbox.alert('没有数据,导出失败');
            }
        }
        </script>
    </html>
  • 相关阅读:
    【面经】网易互娱一面
    【Go】简易到简陋的web服务器
    【Go】连接本地MySQL读取数据
    【MySQL】Windows10下安装
    【深入理解计算机系统】第十三章-并发编程
    【Python】数据库查询 & 批量下载文件
    【深入理解计算机系统】第十二章-网络编程
    grep的时候Binary file matches **.log 怎么解决
    高并发系统架构思想
    mysql 索引
  • 原文地址:https://www.cnblogs.com/chenyangsocool/p/7368299.html
Copyright © 2020-2023  润新知