test.html 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8" />
  5. <meta name="keywords" content="dongke,mes,ibossmes">
  6. <meta name="description" content="制造企业生产过程执行管理系统">
  7. <meta name="author" content="xuwei">
  8. <title>东科软件</title>
  9. <script src="/plugins/xeasyui/xeasyui.min.js"></script>
  10. </head>
  11. <body>
  12. <table id="tabDiv1">
  13. <tr>
  14. <td>ID</td>
  15. <td>姓名</td>
  16. <td>年龄</td>
  17. </tr>
  18. <tr>
  19. <td>0001</td>
  20. <td>张三</td>
  21. <td>24</td>
  22. </tr>
  23. </table>
  24. <table id="tabDiv2">
  25. <tr>
  26. <td>ID</td>
  27. <td>姓名</td>
  28. <td>年龄</td>
  29. </tr>
  30. <tr>
  31. <td>0002</td>
  32. <td>李四</td>
  33. <td>24</td>
  34. </tr>
  35. </table>
  36. <table id="tabDiv3">
  37. <tr>
  38. <td>ID</td>
  39. <td>姓名</td>
  40. <td>年龄</td>
  41. </tr>
  42. <tr>
  43. <td>0003</td>
  44. <td>王五</td>
  45. <td>24</td>
  46. </tr>
  47. </table>
  48. <button onclick="exp();">export to excel...</button>
  49. <script>
  50. function exp() {
  51. $.tablesToExcel(['tabDiv1', 'tabDiv2', 'tabDiv3'], ['sheet1', 'sheet2', 'sheet3'], "testExport.xls", "Excel");
  52. }
  53. </script>
  54. </body>
  55. </html>