js table 导出为Execl

男娘i 2022-04-22 14:02 237阅读 0赞

<a class="btn btn-info btn-xm" style="margin-bottom: 10px;" id="execlOut">导出数据</a>
    <table class="table table-bordered table-hover" id="tableExecl">
        <tr>
            <th></th>
            <th>一</th>
            <th>二</th>
            <th>三</th>
            <th>四</th>
        </tr>
        <tr>
            <td>万籁寂无声</td>
            <td>衾铁棱棱近五更</td>
            <td>香断灯昏吟未稳</td>
            <td>凄清</td>
            <td>只有霜华伴月明</td>
        </tr>
        <tr>
            <td>应是夜寒凝</td>
            <td>恼得梅花睡不成</td>
            <td>我念梅花花念我</td>
            <td>关情</td>
            <td>起看清冰满玉瓶</td>
        </tr>
    </table>
    <script type="text/javascript" src="js/jquery.table2excel.min.js"></script>
    <script>
    	$("#execlOut").click(function() {
            var pageTitle = $('#pageTitle').attr('value');
            var monthName = GetRequest().month ? GetRequest().month : (new Date().getFullYear()) + '-' + (new Date().getMonth()+1);
            var filename = pageTitle + '-' + $('#selectCenter option:selected').text() + monthName + '.xls';
            $("#tableExecl").table2excel({
                // 不被导出的表格行的CSS class类
                exclude: "",
                // 导出的Excel文档的名称，（没看到作用）
                name: "Excel Document Name",
                // Excel文件的名称
                filename: filename
            });
        });
    </script>

**[jquery.table2excel][].js 下载地址：**[https://github.com/rainabba/jquery-table2excel/tree/master/dist][https_github.com_rainabba_jquery-table2excel_tree_master_dist]

[jquery.table2excel]: https://github.com/rainabba/jquery-table2excel
[https_github.com_rainabba_jquery-table2excel_tree_master_dist]: https://github.com/rainabba/jquery-table2excel/tree/master/dist