master

分支 (1)

管理

管理

master

easyui-ExpandFunc
/
export.html

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8" />
        <title>JS-XLSX Demo</title>
        <!-- <script type="text/javascript" src="./xlsx.core.min.js"></script> -->
        <script src="./exportBase.js"></script>
    </head>
    <body>
        <table id="data-table" border="1" width="50%">
            <tbody>
                <tr>
                    <th rowspan="2">编号</th>
                    <th rowspan="2">名称</th>
                    <th colspan="2" style="background-color: blue; text-align: center">价格</th>
                    <!-- <td>日期</td> -->
                </tr>
                <tr>
                    <th>1</th>
                    <th>1</th>
                </tr>
                <tr>
                    <td>1</td>
                    <td>《Java架构师》<b>123</b></td>
                    <td>￥78.5</td>
                    <td>2018-10-11</td>
                </tr>
                <tr>
                    <td>2</td>
                    <td>《Python入门到精通》</td>
                    <td>￥65.3</td>
                    <td>2019-03-22</td>
                </tr>
                <tr>
                    <td>3</td>
                    <td>《JavaScript高级教程》</td>
                    <td>￥89.4</td>
                    <td>2017-04-13</td>
                </tr>
            </tbody>
        </table>

        <p>将上面表格的内容导出到Excel文件</p>
        <p>
            <button onclick="exportExcel()">导出Excel</button>
        </p>
        <!-- <script src="./index.js"></script> -->
        <script>

            function exportExcel() {
                // 获取表格的Dom对象
                var elt = document.getElementById("data-table");

                //创建Excel工作簿，即一个Excel文件
                var wb = XLSX.utils.table_to_book(elt, {
                    sheet: "SheetJS", // 工作表格名称
                });
                wb.Sheets.SheetJS.A1.s = {
                    font: {
                        sz: 18, //18号字体
                        bold: true, //加粗
                    },
                    alignment: {
                        horizontal: "center", //水平居中对其
                    },
                };
                var wopts = { bookType: "xlsx", type: "binary" };
                var wbout = XLSX.write(wb, wopts);
                function s2ab(s) {
                    var buf = new ArrayBuffer(s.length);
                    var view = new Uint8Array(buf);
                    for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xff;
                    return buf;
                }
                var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" });

                function saveAs(obj, filename) {
                    var link = document.createElement("a");
                    link.download = filename;
                    link.href = URL.createObjectURL(obj);
                    link.click();
                    URL.revokeObjectURL(obj);
                }
                saveAs(blob, "out.xlsx");
            }
        </script>
    </body>
</html>