Jen, While not a direct answer to your question, I'd recommend you look into using jExcelApi (http://www.andykhan.com/jexcelapi/.) It's a pure Java API for reading/writing Excel files. It's pretty easy to write a CFC wrapper for it.
COM support in CFMX isn't all that great and many COM objects are unusable or may cause instability in your application (this is obviously very case-by-case scenario.) -Dan >-----Original Message----- >From: CHANCE, JENNIFER M. (JSC-BJ) (BAS) >[mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 03, 2005 12:04 PM >To: CF-Talk >Subject: Cfobject Excel Com > >I am trying to create an Excel COM object. > > >"<CFTRY> > <!--- If it exists, connect to it ---> > <CFOBJECT ACTION="CONNECT" CLASS="Excel.Application" NAME="objExcel" >TYPE="COM"> > <CFCATCH> > <!--- The object doesn't exist, so create it ---> > <CFOBJECT ACTION="CREATE" CLASS="Excel.Application" NAME="objExcel" >TYPE="COM"> > </CFCATCH> ></CFTRY>" > >And I get this error: > > >"An exception occurred when instantiating a Com object. >The cause of this exception was that: >coldfusion.runtime.java.JavaObjectInstantiationException: Object >Instantiation Exception.. > >10 : <CFCATCH> >11 : <!--- The object doesn't exist, so create it ---> >12 : <CFOBJECT ACTION="CREATE" CLASS="Excel.Application" >NAME="objExcel" >TYPE="COM"> >13 : </CFCATCH> >14 : </CFTRY>" > >Does anyone know what is going wrong? > >Thanks, > >Jen > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213611 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
