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