Guest User

Untitled

a guest
Jun 21st, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. <table id="exportable">
  2. <thead>
  3. <tr>
  4. <th>Column1</th>
  5. <th>Column2</th>
  6. <th>Column3</th>
  7. <th>Column4</th>
  8. <th>Column5</th>
  9. <th>Column6</th>
  10. </tr>
  11. </thead>
  12. <tbody>
  13. <tr>
  14. <td>Value1</td>
  15. <td>Value2</td>
  16. <td>Value3</td>
  17. <td>Value4</td>
  18. <td>Value5</td>
  19. <td>Value6</td>
  20. </tr>
  21. </tbody>
  22.  
  23. function exportData() {
  24. alasql("SELECT * INTO XLSX('UsecaseReport.xlsx',{headers:true})
  25. FROM HTML('#exportable',{headers:true})");
  26. };
  27.  
  28. <table id="exportable">
  29. <thead>
  30. <tr>
  31. <th colspan="2"></th>
  32. <th colspan="2">Group Header</th>
  33. <th colspan="2"></th>
  34. </tr>
  35. <tr>
  36. <th>Column1</th>
  37. <th>Column2</th>
  38. <th>Column3</th>
  39. <th>Column4</th>
  40. <th>Column5</th>
  41. <th>Column6</th>
  42. </tr>
  43. </thead>
  44. <tbody>
  45. <tr>
  46. <td>Value1</td>
  47. <td>Value2</td>
  48. <td>Value3</td>
  49. <td>Value4</td>
  50. <td>Value5</td>
  51. <td>Value6</td>
  52. </tr>
  53. </tbody>
Add Comment
Please, Sign In to add comment