TableExport icon indicating copy to clipboard operation
TableExport copied to clipboard

table formatting not exported in xls and xlsx

Open matarum opened this issue 7 years ago • 0 comments
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,",",".") . '
but when i export to xls or xlsx, my file is not formatted, text bottom aligned and 10,71 column width

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?

matarum avatar Jun 27 '18 15:06 matarum