Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will "function" exactly like excel. The following code will trick the browser into thinking it's dealing with excel: <CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=sample.xls"> <CFCONTENT TYPE="application/excel">
If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file > trouble is, I cant do it all in 1 query, I have cf logic that HAS to be > there, and it is then emailed to a client :( so, is there a way to take > a cfquery object that is returned, and just dump that into something, > and send it, versus writing line by line by line.... > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Craig Dudley [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 10:53 AM > To: CF-Talk > Subject: RE: query output to Excel file > > > Youre using SQL server yes? > > So DTS would be the best option for that amount of data, Jon Hall posted > all about it a few months back, check the archives. > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: 04 September 2003 15:54 > To: CF-Talk > Subject: RE: query output to Excel file > > > id love to know myself, I have a query that returns an assload of data, > that I have to write to csv, and now it takes 45 minutes to > complete...there has to be a better way! > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Petr Kysela [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 10:45 AM > To: CF-Talk > 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=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
