beautifying CSV files

[Ravi Krishna]

Hi,


I generate a CSV file thru Perl and attach it in email. The CSV file can be
directly read by Excel and it looks great. However I am not able to be highlight
any row or column, like the total column at the bottom.

Is there a way I can embed them in a CSV file. I don't think so, but hey, someone
can comeup with a suggestion.

Alternatively can I generate a file in XML which can be read by Excel along with
fonts, color codes etc.

Thanks.

Ravi

 

[Jim Rech]

CSV is "format free", as far as I know.

I think XML is a viable way to go, if you have Excel 2002 or 2003 and want
to delve into "SpreadsheetML".


http://www.microsoft.com/office/xml/default.mspx

 

[Dennis]

Hello Ravi

By definition, (as seen during the Save dialog) .CSV files do not retain formatting.

Send Two files!

One for display (a regular .XLS file) with special formatting

Second as a .CSV file for importing or whatever.

Dennis