Try something like this.
<CFQUERY name="Dynamic" datasource="#Session.dsn#">
#PreserveSingleQuotes(MyQueryString)#
</CFQUERY>
<CFSAVECONTENT variable="mynewxlsfile">
<CFOUTPUT>
<Table>
<CFLOOP query="Dynamic">
<TR>
<TD>#Dynamic.FldName1#</TD>
<TD>#Dynamic.FldName2#</TD>
<TD>#Dynamic.FldName3#</TD>
</TR>
</CFLOOP>
</TABLE>
</CFOUTPUT>
</CFSAVECONTENT>
<CFOUTPUT>
<CFSET FileToWrite =
"QueryResults_Date#dateformat(Now(),'dd-mm-yyy')#_Time#Timeformat(Now(),'hhm
msstt')#.xls">
<CFFILE action="WRITE" output="#mynewxlsfile#"
File="d:\somedir\#FileToWrite#" nameconflict="OVERWRITE">
</CFOUTPUT>
HTH
DavidB
-----Original Message-----
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 10:05 AM
To: CF-Talk
Subject: RE: query output to Excel file
What's the code look like for "pushing an ordinary html table as a file with
an .xls extention
using cfcontent"? Can you give an example for us?
Rick
> -----Original Message-----
> From: Chris Stoner [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 4:37 PM
> To: CF-Talk
> Subject: Re: query output to Excel file
>
>
> push an ordinary html table as a file with an .xls extention using
> cfcontent.
>
>
> ----- Original Message -----
> From: "Petr Kysela" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, September 04, 2003 10:45 AM
> Subject: query output to Excel file
>
>
> > What would you say is the best way of creating an Excel
> file from query
> > data?
> > I don't need to know how to create a .csv file.
> >
> > I've seen solutions through ADO objects, ODBC dsn, custom
> tags, etc.
> >
> > But surely there must be something quick and easy.
> >
> > Cheers
> >
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~|
> Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
> Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
> Unsubscribe:
> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
>
> Signup for the Fusion Authority news alert and keep up with
> the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
