Issue288.html 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>HTML table Export</title>
  6. <script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
  7. <script type="text/javascript" src="../libs/js-xlsx/xlsx.core.min.js"></script>
  8. <script type="text/javascript" src="../libs/FileSaver/FileSaver.min.js"></script>
  9. <script type="text/javascript" src="../tableExport.js"></script>
  10. <script type="text/javaScript">'use strict';
  11. function doExport () {
  12. $('#tab_isee').tableExport({
  13. type: 'excel',
  14. date: {html: 'dd/mm/yyyy'},
  15. mso: {fileFormat: 'xlsx'},
  16. xslx: {formatId: {date: 14, numbers: 2}},
  17. numbers: {html: {decimalMark: ',', thousandsSeparator: '.'},
  18. output: {decimalMark: '.', thousandsSeparator: ''}}
  19. });
  20. }
  21. </script>
  22. </head>
  23. <body>
  24. <a href="#" onclick="doExport()">Export to XLSX</a>
  25. <table class="table table-hover" id="tab_isee">
  26. <thead>
  27. <tr>
  28. <th>N. Rapp.</th>
  29. <th>Rapporto</th>
  30. <th>Consulente</th>
  31. <th>Dt. Inizio Rapp.</th>
  32. <th>Dt. Fine Rapp.</th>
  33. <th>Società</th>
  34. <th>Prodotto</th>
  35. <th>Tipo</th>
  36. <th>N. contratto</th>
  37. <th>N. Portaf.</th>
  38. <th>Dt. stipula Contr.</th>
  39. <th>Dt. recesso Contr.</th>
  40. <th>Patrimonio</th>
  41. <th>Isin</th>
  42. <th>Qta</th>
  43. <th>Dep.</th>
  44. </tr>
  45. </thead>
  46. <tbody>
  47. <tr>
  48. <td data-tableexport-cellformat="">5496</td>
  49. <td>(1.Intest)</td>
  50. <td>00001 Consultinvest Investimenti Sim Spa - cl. diretti</td>
  51. <td data-tableexport-xlsxformatid="14" nowrap="">01/02/2006</td>
  52. <td data-tableexport-xlsxformatid="14" nowrap="">03/03/2015</td>
  53. <td>Amundi Sgr Spa</td>
  54. <td>Seconda Pensione Sicurezza</td>
  55. <td>Fondi Pensione</td>
  56. <td data-tableexport-cellformat="">1500262194</td>
  57. <td data-tableexport-cellformat="">341827</td>
  58. <td data-tableexport-xlsxformatid="14" nowrap="">11/06/2007</td>
  59. <td data-tableexport-xlsxformatid="14" nowrap="">01/04/2008</td>
  60. <td>0</td>
  61. <td></td>
  62. <td>0</td>
  63. <td></td>
  64. </tr>
  65. </tbody></table>
  66. </body>
  67. </html>