has anyone done been able to script an excel export method?
for csv, I build them myself since the embedded export is only manual, but I ignore the excel specs to generate an excel file directly, and when exporting csv, excel keeps removing leading 0 on numbers even if you double quote them. only a single quote avoid this, but this is visible after export…
as the excel is present in the menu, there should be a way to script this export sequence?
Hi Serge,
what you can also do is use html to create an Excel file! Basically you body will contain a html table.
And if you use Excel styles, then you can format your export the way you want.
An easy way to know what style to use for a cell is to create and Excel file with a few cells using different styles/format, then save it to html, open it in a text editor and you will see that in the header of that file there are the styles (quite verbose but it’s Microsoft after all!) that you can copy for your own use…
That’s the way I do it know. A lot easier than using Jakarta POI low level Java lib, I can tell you!
good point, that’s what I do when using php, except that I never thought reading inside an excel generated html.
as a matter of fact, just changing the extension of a html file formatted such a way, and excel reads it back perfectly.
merci!