Hello Ron,
i didn't know about ADTransform and will look at it. Actually, my goal
is to make an export file and it seems to allow spreadsheet output.
But i already had the need to make a spreadsheet to xml conversion for
import purpose, so i'll keep that in mind (and your post in adtransform
website)
Thanks !
Leila
Le 19/03/2016 02:38, Ron Wheeler a écrit :
ADTransform will do most (perhaps all) of what you want.
It will read a spreadsheet (or a CSV file), let you manipulate the
data, verify it and then produce a set of XML files.
I have done a partial script to take multiple spreadsheets and create
OFBiz XML entity files.
The OFBiz XML structure is fairly complex and to load a simple
spreadsheet containing a list of customers with their names,
addresses, email, phone numbers starts with a pretty simple
spreadsheet but ends up with many, many XML files. Spreadsheets with
Customers, Customer Service employees and SIC codes generate 19 XML
files!
Ron
On 18/03/2016 6:05 AM, Leila wrote:
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
