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/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?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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]