Tony: CSV is simply a text-based format for representing data. It doesn't allow for the representation of formatting. CSV is simply:
Record1Data1,Record1Data2 Record2Data1,Record2Date2 etc. If you intend to send the CSV file to the web user with an Excel Mime-Type (i.e., have it open in Excel automatically), you might consider dumping the data into an HTML table instead of CSV. Later versions of Excel (don't remember when it started) are able to interpret HTML tables directly. Just set the Mime-Type to Excel and CFOUTPUT the HTML table as normal. Using HTML, you could set ROWSPAN, COLSPAN, background colors, etc. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 10:12 AM > To: CF-Talk > Subject: csv file question > > > hi all. > > I am finishing up a downloadable csv file for a client > and was wondering if there is any way known to make a column in > a csv file span two above it? like we do with tables, but > in a csv file? > > thanks. > > ..tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.