1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>HTML table Export</title>
- <script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
- <script type="text/javascript" src="../libs/js-xlsx/xlsx.core.min.js"></script>
- <script type="text/javascript" src="../libs/FileSaver/FileSaver.min.js"></script>
- <script type="text/javascript" src="../tableExport.js"></script>
- <script type="text/javaScript">'use strict';
- function doExport () {
- $('#tab_isee').tableExport({
- type: 'excel',
- date: {html: 'dd/mm/yyyy'},
- mso: {fileFormat: 'xlsx'},
- xslx: {formatId: {date: 14, numbers: 2}},
- numbers: {html: {decimalMark: ',', thousandsSeparator: '.'},
- output: {decimalMark: '.', thousandsSeparator: ''}}
- });
- }
- </script>
- </head>
- <body>
- <a href="#" onclick="doExport()">Export to XLSX</a>
- <table class="table table-hover" id="tab_isee">
- <thead>
- <tr>
- <th>N. Rapp.</th>
- <th>Rapporto</th>
- <th>Consulente</th>
- <th>Dt. Inizio Rapp.</th>
- <th>Dt. Fine Rapp.</th>
- <th>Società </th>
- <th>Prodotto</th>
- <th>Tipo</th>
- <th>N. contratto</th>
- <th>N. Portaf.</th>
- <th>Dt. stipula Contr.</th>
- <th>Dt. recesso Contr.</th>
- <th>Patrimonio</th>
- <th>Isin</th>
- <th>Qta</th>
- <th>Dep.</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td data-tableexport-cellformat="">5496</td>
- <td>(1.Intest)</td>
- <td>00001 Consultinvest Investimenti Sim Spa - cl. diretti</td>
- <td data-tableexport-xlsxformatid="14" nowrap="">01/02/2006</td>
- <td data-tableexport-xlsxformatid="14" nowrap="">03/03/2015</td>
- <td>Amundi Sgr Spa</td>
- <td>Seconda Pensione Sicurezza</td>
- <td>Fondi Pensione</td>
- <td data-tableexport-cellformat="">1500262194</td>
- <td data-tableexport-cellformat="">341827</td>
- <td data-tableexport-xlsxformatid="14" nowrap="">11/06/2007</td>
- <td data-tableexport-xlsxformatid="14" nowrap="">01/04/2008</td>
- <td>0</td>
- <td></td>
- <td>0</td>
- <td></td>
- </tr>
- </tbody></table>
- </body>
- </html>
|