TableExport
TableExport copied to clipboard
table formatting not exported in xls and xlsx
trafficstars
I have a table like that:
| Cognome | Nome | Ente | Data inizio | Data fine | Moduli completati | Ore |
|---|---|---|---|---|---|---|
| ' . $utente['lastname'] . ' | ' . $utente['firstname'] . ' | ' . $utente['ente'] . ' | ' . $dataInizio . ' | ' . $dataFine . ' | ' . explode("§§§", $moduli) . ' | ' . number_format($totaleOre,1,",",".") . ' |
here is how i call tableExport:
$(document).ready(function(){ var instance = $("#tabella").tableExport({ headers: true, footers: true, formats: ["xlsx"], filename: "Report_SI_' . date('Ymd') . '", exportButtons: false, bootstrap: false, //tried also true, but no luck ignoreRows: null, ignoreCols: null, ignoreCSS: ".tableexport-ignore", emptyCSS: ".tableexport-empty", trimWhitespace: false }); exportData = instance.getExportData()["tabella"]["xlsx"]; $(".export").click(function() { instance.export2file(exportData.data, exportData.mimeType, exportData.filename, exportData.fileExtension); }); });
there's some reason why?