Yep, but I've found it's easier to format it in HTML. You can do some funky things - like using Excels native number formats (in other words, getting a number that starts with a zero to show the zero in excel), highlighting various columns, etc. It depends on what you need to do.
-d ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 10:55 AM Subject: RE: query output to Excel file > but I could in the same light, write the data as comma delimited inside > a cfsavecontent? > > and then from there...dump the data in the cfsavecontent into the > cffile, as one file system hit? > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 11:34 AM > To: CF-Talk > Subject: Re: query output to Excel file > > > 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
