html页面里table导出为excel_html/css_WEB-ITnose
程序员文章站
2024-01-18 13:29:46
...
只要想不到，没有做不到，一直都不知道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 | |