I've just had a thought! Hey, come back... :OP If I include a cfcontent tag at the bottom of my App.cfm file, will that take care of all the extra white space without the need for cfsilent/cfsetting with enablecfoutputonly set to yes AND not mess with anything like the response headers?!
Ron, if you can't get the headers sorted, have a look at generating html instead, Excel will turn simple html into what you're after. You can use this technique to format the excel file with background colours and make font bold etc. Whatever happens, let us know how you get on. Ade -----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 15 January 2005 00:29 To: CF-Talk Subject: Re: Creating .xls files with column headers Sometimes I wonder if it wouldn't help to learn to read English... Yeppers, a quick perusal of the LiveDocs for 6.1 reveals my misunderstanding. I thought it discarded the content AFTER the request was processed... But, you're right, it discards all content from before the cfcontent tag was issued. However, it's default is YES, and the attribute is provided to protect against discarding chunks of pages that have content generated before and after the call to cfcontent (i.e. using CFCONTENT to provide inline animations). Since it's not being specified, it's default is already yes. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com On Sat, 15 Jan 2005 00:19:25 -0000, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Good point. > > As for the reset attribute, I thought it determined whether all output > before the tag was discared or not. Using it will take care of any unwanted > white space. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 12/01/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
