JavaWorld
addict
Reged: 06/20/03
Posts: 482
|
|
Converting XML to spreadsheet, and vice versa
|
Kalpesh
stranger
Reged: 09/25/03
Posts: 3
|
|
This is a very very complex way and its just showing how to use xml and how to use excel and usign them in tandem. What people want is an API like JAXB where you can marshal or unmarshal to xml from Java.
|
Mesirii
Unregistered
|
|
This is one of the worst articles I ever read (within 5 minutes). There is no abstraction at all you are always faster copying the values of the xml file to excel and vice versa. This code does not support different value types, column names, etc. It would be so simple to provide a generic solution mapping named cells to xml elements. And why using DOM if SAX would be more than sufficient (and for writing the values a homegrown solution, would be the easiest way).
I'm deeply disappointed.
Michael
|
Unregistered
|
|
Agreed,
'..Ajay Vohra is senior architect at DataSynapse, currently working on virtualizing business-critical applications on a shared infrastructure...'
It really makes me curious what 'architecture' they would be using
|
Unregistered
|
|
This could be done a lot more easily using XSLT to convert to MS Excel xml format. Poor article.
|
Unregistered
|
|
OR you could use the automated CellBinder API found here. It's not free, but then you get what you pay for! It's the most robust, automated all Java spreadsheet API there is.
|
Previous
Index
Next
Threaded
Edit
Reply
Quote
