It can also output HTML files fully annotated for CSS styling.
It also can create reports using JasperReport.
It can read CSV (with and without headers) and Excel files.
It can be extended by plug-ins to read anything that you can parse into
row and columns
Webservice and SQL connections are possible sources for data.
Ron
On 21/03/2016 9:16 AM, Leila Mekika wrote:
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
--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102