Can the column widths be resized dynamically to their widest value? What I found was that, without any VBScript or COM automation, this was not possible.
I would be interested in seeing an example of doing this another way, if anyone has one. Mike -----Original Message----- From: list peters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:16 AM To: CF-Talk 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 client now > wants the width of the spreadsheet columns being generated to automatically > size to the length of the longest string returned from the query. Does > anyone know whether this is possible, maybe with <cfobject>? > > No luck so far with cfcomet. > > Tristram Charnley > --------------------------- > [EMAIL PROTECTED] > Allaire Certified ColdFusion Developer > > > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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