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
