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.
Depending on the sophistication of the office doc you want you might try the following as alternatives to the app on server option or even calling COM at all.
--// Fake Word
You could generate HTML and just deliver it via CFCONTENT as .DOC or .XLS. Clever use of MS styles and the like can lead to pretty sophisitcated docs and sheets. For excel you create HTML tables... you can even populate them with formulas.
Sam Neff talks a bit about this and other approaches here: Serving Word (complete with Breezo) http://www.rewindlife.com/archives/000032.cfm
--// Java (Apache POI)
http://jakarta.apache.org/poi/
"The POI project consists of APIs for manipulating various file formats based upon Microsoft's OLE 2 Compound Document format using pure Java. In short, you can read and write MS Excel files using Java. Soon, you'll be able to read and write Word files using Java. POI is your Java Excel solution as well as your Java Word solution. However, we have a complete API for porting other OLE 2 Compound Document formats and welcome others to participate."
Dave Ross has a great note specifically how to use POI with Excel... should be useful start for most any application of the technology in CFMX:
Generating Excel spreadsheets from CFMX
http://www.d-ross.org/index.cfm?objectid=9C65ED5A-508B-E116-6F4F7F38C6AE167C
Hope that helps,
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
