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 > > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
