jQuery表格导出Excel文件

查看演示立即下载

插件描述：使用jQuery，jszip.js，FileSaver.js,excel-gen.js将网页中表格导出到本地Excel文件

使用方法

需要引用以下几个主要文件

<script src="/"></script>
<script type="text/javascript" src="jszip.min.js"></script>
<script type="text/javascript" src="external/FileSaver.js"></script>
<script type="text/javascript" src="scripts/excel-gen.js"></script>
<script type="text/javascript" src="scripts/demo.page.js"></script>

html表格数据,表格id为test_table

<table class="table table-bordered table-striped" id="test_table">
    <thead>
        <tr>
            <td>等级</td>
            <td>姓名</td>
            <td>城市</td>
            <td>州</td>
            <td>部门</td>
            <td>选取</td>
            <td>票数</td>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>
                <span>1</span>
            </td>
            <td>
                <span>Small, Steve </span>
            </td>
            <td>
                <span>New York</span>
            </td>
            <td>
                <span>NY</span>
            </td>
            <td>
                <span>Eastern</span>
            </td>
            <td>
                <span>Metropolitan Region</span>
            </td>
            <td>
                <span>378</span>
            </td>
        </tr>
        <tr>
            <td>
                <span>2</span>
            </td>
            <td>
                <span>Novello, Rodolfo </span>
            </td>
            <td>
                <span>Lawrence</span>
            </td>
            <td>
                <span>NY</span>
            </td>
            <td>
                <span>Eastern</span>
            </td>
            <td>
                <span>Long Island Region</span>
            </td>
            <td>
                <span>223</span>
            </td>
        </tr>
 
         </tbody>
</table>

js代码

$(document).ready(function () {
    excel = new ExcelGen({
        "src_id": "test_table",
        "show_header": true
    });
    $("#generate-excel").click(function () {
        excel.generate();
    });
});

特别申明：
本站所有资源都是由网友投稿发布，或转载各大下载站，请自行检测软件的完整性！
本站所有资源仅供学习与参考，请勿用于商业用途，否则产生的一切后果将由您自己承担！
如有侵权请联系我们删除下架，联系方式：lei1294551502@163.com

上一个特效： jQuery自定义selects输入框
下一个特效： jQuery抽奖可制定每次抽奖数