Anyone creating and reading Excel or Word docs using XML& CFMX?

[RustyAxe]

Hi Just wondering if anyone on the list is using CF and XML to create and / or
read Excel or Word docs. We have apps using Excel and Word server-side to
create and read Excel files and create Word files. We know this is not
recommened but the app is almost 3 years old and using Excel and Word
server-side was the most appropriate option at the time. MS finally released
the XML schema for Excel and Word last year
([url]http://www.microsoft.com/office/xml/default.mspx[/url]) and we are now considering
using XML or POI using CFMX on Linux If you have attempted (whether
successfully or not) to create and read Excel or Word docs using XML (or POI)
I'd appreciate it if you could share your experience here. Cheers Nathan

[Kronin555]

Hey Nathan,

I've been using POI for almost 2 years now to parse uploaded excel files. As
long as you know the limitations and can live with them, it works great
(formula support is lacking, I ended up writing some menial formula support
into my parser). I haven't done anything with word docs, so I can't help you
there. Nor have I done any excel file creation, simply reading.

I was previously using POI in a J2EE app, so I already had experience in it,
and a nice friendly wrapper class written to utilize it. I just call that
wrapper class from CF using createobject.

[RustyAxe]

Thanks Kronin555

I haven't found many people out there using XML but quite a few using POI so we may give POI a go.

Cheers

Nathan