Gaston,
Thanks, that's exactly what I needed - being able to format the actual
spreadsheet that easily!
I have just one question: do you know how to include images within the
spreadsheet - if i reference them using normal html code, they don't
appear to work.
Cheers!
Seth
-----Original Message-----
From: Nardi, Gaston [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2000 16:35
To: CF-Talk
Subject: RE: Creating Excel Documents
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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
________________________________________________________________________
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
________________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
