html页面里table导出为excel_html/css

来源：哈瑞养生

只要想不到，没有做不到，一直都不知道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

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