A couple of things to keep in mind:
You cannot link directly to a file.xls. First of all, the web server won't
execute any commands in here (cf code) because it's an xls file, not a cfm
file. Additionally, the file won't work properly in Excel because it'll be
filled with ASCII, not "Excel code" (at least in your current
implementation).
CF_Excel actually uses CFContent to create a file that is a .csv; that is,
it is comma delimited. Excel can handle this file; however, you will not be
able to do any "Excel formatting". I'd recommend using CFX_Excel, which
will actually use Excel 97 + (which must be installed on the server) to
create a true .xls file. Very cool.
Billy
----- Original Message -----
From: "Akbar Pasha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 2:03 AM
Subject: cf_excel??
> Is it the proper use of custom tag <cf_excel> . i want to take the
resultset
> which is on the browser to excel sheet
> with the same result set appearing in the sheet. but with this tag i
> managed to pass the link to webpage to
> excel sheet. but there i could able to see the same code instead of
result
> set.
>
> in the first file i given link to xls file like this
> <a href="filename.xls">Go to Excel</a>
> in filename.xls i wrote following customtag code
> <cfset a=#session.cID#>
> <cfset b=#dateformat(session.sdate,"mm/dd/yy")#>
> <cfset c=#dateformat(session.edate,"mm/dd/yy")#>
> <cfoutput>
> <cf_excel
> Datasource="dsnname"
> Tableheadings = "Bank,Branch,Name,Account,Amount"
> DataFields="bank,brn,name,Acno,visitamt"
> SQLCommand="select cc.bank,cc.name,cc.BRN,cc.ACNo,visit.visitamt from
> cc,visit where cc.cID=#a# and visit.eom=1 and visit.cid= cc.cid and
> visitdate between #b# and #c# order by cc.cID">
> </cfoutput>
>
> so, in the excel sheet i'm getting same code in cfoutput tag not the
> records.
>
> thankx in advance
> nagesh
>
> p.s. can anyone tell me how to insert records in a excel sheet from cold
> fusion?
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
