Hello everyone,
We had to do a spreadsheet file handler for a customer project and
decided to use current csv renderer to generate a datafile, then convert
it to xls with Workbook library.
It turns out to be very long when extracted file reaches a big load of
data...
In order to resolve this, i am currently trying to make a new handler
that generate a html table file which can be imported as spreadsheet in
most office software suite (i've made a JIRA
<https://issues.apache.org/jira/browse/OFBIZ-6931>). Cells are formatted
via css (found this
<http://niallodoherty.com/post.cfm/basic-html-to-excel-formatting>).
The generated file is an html file with application/xls response
content-type, since i didnt' find any "html to ods" or "html to xls"
converter. I think it's because it can be done from the software suite
interface, but i was wondering: does anyone know of a library that can
transform html to spreadsheet file ?
Does anyone has another suggestion than the html generation to achieve a
fast spreadsheet file rendering ?
Thanks for any idea or advice
Leila Mekika