Thanks Shi for your answer,
Sorry i didn't express myself well: in fact i was refering to POI when i
said that we use to convert the csv to xls with workbook library.
But we've got memory issues with some files so i try to find an other
way :-)
Leila
Le 19/03/2016 01:31, Shi Jinghai a écrit :
I think POI is the right way, you can handle an excel template file directly
without any conversion.
It's in my plan (maybe in May) to contribute a PriCat component which can
import/export excel file for EDI purpose.
Kind Regards,
Shi Jinghai
-----邮件原件-----
发件人: Leila [mailto:leila.mek...@nereide.fr]
发送时间: 2016年3月18日 18:05
收件人:dev@ofbiz.apache.org
主题: Spreadsheet file handler creation
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
