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.

Reply via email to