Yes, but it requires Excel 2000....perhaps I can persuade them to upgrade. Meanwhile I was hoping CFOBJECT would do the trick.
----- Original Message ----- From: "list peters" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 8:16 AM Subject: Re: CFOBJECT and Excel Column widths > ben forta described how to do this (variable width columns), along with > formatting etc in his web application construction kit book. > > start a new excel document, and enter a test row how you would like... apply > all formatting, column widths, etc, and then save as HTML. > Open up the HTML file created, stick in your query, and your cfoutputs > around the tables (like you would normally), and then serve it up with > cfcontent. > > goodluck! > > chad > > > > I've been using <cfcontent> to output query results in Excel. My clie nt > now > > wants the width of the spreadsheet columns being generated to > automatically > > size to the length of the longest string returned from the query. Doe s > > anyone know whether this is possible, maybe with <cfobject>? > > > > No luck so far with cfcomet. > > > > Tristram Charnley > > --------------------------- > > [EMAIL PROTECTED] > > Allaire Certified ColdFusion Developer > > > > > > > > > > _____________________________________________________________________ _ > > Dedicated Windows 2000 Server > > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > > Instant Activation · $99/Month · Free Setup > > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
