html页面里table导出为excel_html/css_WEB-ITnose
程序员文章站
2022-04-22 19:26:13
...
只要想不到,没有做不到,一直都不知道html里table元素可直接导出为excel,太牛逼了!
这其中用到一个jquery的插件table2excel
使用方法也很简单:
1 。 包含必要的文件
2。 创建导出按钮
3。 给导出按钮添加事件
$(".table2excel").table2excel({ exclude: ".noExl", // 不想导出的行加上class='noExl'即可 name: "Excel Document Name", // excel文档名 filename: "myFileName" // excel文件名});
完整的看下DEMO
jQuery Boilerplate
This shouldn't get exported | This shouldn't get exported either |
This Should get exported as a header | This should too |
data1a | data1b |
data2a | data2b |
This footer spans 2 cells |
This shouldn't get exported | This shouldn't get exported either |
This Should get exported as a header | This should too |
data1a | data1b |
data2a | data2b |
This footer spans 2 cells |