(http://sourceforge.net/projects/openxcf). It allows you to read XLS
files as CF queries and write XLS files using CF queries.
-Matt
On Apr 16, 2004, at 10:07 PM, Johnny Le wrote:
> I follow the article "How to transfer records from SQL to Excel -- the
> better way" from cfcomet.com and I got this error.��What do I
> do?��Please help.
>
> An exception occurred when accessing a Com object field.��
> The cause of this exception was that:
> coldfusion.runtime.CfJspPage$ComplexObjectException: Complex object
> types cannot be converted to simple values..��
> ��
> The error occurred in C:\Inetpub\wwwroot\NEO\eap\excel.cfm: line 25
>
>
> 23 :
> 24 : <!--- Open and activate the workbook --->
> 25 : <CFSET objBook = objBooks.Open(File)>
> 26 : <CFSET objBook.Activate()>
>
> Thank you.
>
> Johnny
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
