Hi. Look into ColdFusion at www.webtricks.com
Selene uses a <cfcontent type="text/tabdelimited"> to creates the Excel
file.
Good Luck.
Gastón
> -----Mensaje original-----
> De: Dave Hannum [SMTP:[EMAIL PROTECTED]]
> Enviado el: Miércoles 18 de Octubre de 2000 09:21
> Para: CF-Talk
> Asunto: Re: Creating Excel Documents
>
> Have you tried using QueryNew, QuerySetCell and QueryAddRow in conjunction
> with CFX_Excel? I use it here with tremendous success on some very
> heavily
> used applications. You need to have Excel on the server to use this, but
> it
> work great! I creates the Excel file on the server, then using CFCONTENT
> you can download the file and delete it off the server to keep things
> tidy!
>
> Dave
>
>
> =================================
> "What we need is a list of specific unknown problems we will encounter"
>
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
>
>
>
> ----- Original Message -----
> From: "seth ward" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 18, 2000 6:59 AM
> Subject: Creating Excel Documents
>
>
> I am desperately trying to output the contents of a query into a new
> Excel document; I have just about managed to open Excel on the client's
> machine using cfobject and some cfscript but it seems that i just get
> errors when trying to follow the Microsoft Visual Basic instructions in
> Excel.
>
> I can't seem to actually enter any data, save the worksheet or
> anything...
>
> The code I can use successfully is below. The problem I get is if I then
> try to use
> newDoc.Range("A1").Value = 1;
>
> to set the first cell in the worksheet to have a value of 1.
>
> I get an invalid parser error, even though it is the exact syntax copied
> from the example given on the range property.
>
> HELP, Please! Is there an easier way???
>
> ----------------
> code begins
> ---------------
>
>
> <CFTRY>
>
> <CFOBJECT
> ACTION="CONNECT"
> CLASS="Excel.Application"
> NAME="objExcel"
> TYPE="COM">
> <CFCATCH>
>
> <CFOBJECT
> ACTION="CREATE"
> CLASS="Excel.Application"
> NAME="objExcel"
> TYPE="COM">
> </CFCATCH>
> </CFTRY>
>
>
> <CFSCRIPT>
> /* This will open Excel if running locally */
> objExcel.Visible = true;
>
> /* This returns the 'Documents' collection the Excel Object */
> objBook = objExcel.Workbooks;
>
> /* Create a new document */
> newDoc = objBook.add();
>
>
> </CFSCRIPT>
>
>
> --------------
> code ends
> --------------
>
> seth ward
>
> ________________________________________________________________________
> This message has been checked for all known viruses, by Star Internet,
> delivered through the MessageLabs Virus Control Centre.
> For further information visit:
> http://www.star.net.uk/stats.asp
>
> --------------------------------------------------------------------------
> --
> --------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
> ----------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
