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
--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102