I do it a couple of ways. First, you can create a comma delimited file
(.csv) and then using cfcontent, deliver it right to the browser to be
downloaded, or you can write it to the server to be downloaded later. Or, I
often use the CFX_EXCEL custom tag from the exchange. You need Excel on the
server and be sure to LOCK properly, but this produces an actual .xls file.
Again, you can either download directly or write to the hard drive. Either
way works.
Dave
----- Original Message -----
From: "David Baskin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 7:50 PM
Subject: CF and Excel
> Hello, i've been tasked with taking data out of a SQL database and
inserting
> it into an excel spread sheet. I went to CFComet and read through their
> instructions and ran their sample code, but i cannot get it to work. I get
> the following error:
>
> Error Diagnostic Information
> Error trying to create object specified in the tag.
>
> COM error 0x80040154. Class not registered
>
> Does anyone know how best to connect and write to excel and if there is a
> good tutorial that i can learn from. Creating and connecting to objects is
> new to me, so i'm a little lost. Thanks for any help.
>
> david
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
