前端JS指令碼將網頁表格匯出為Excel

來源:互聯網
上載者:User

標籤:www.   splay   width   xmlns   失敗   padding   org   innerhtml   alert   

話不多說,上代碼!

<!DOCTYPE><html>    <head>        <title>Excel Test</title>    </head>        <body>        <div style="width: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="width: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>

 

前端JS指令碼將網頁表格匯出為Excel

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.