Exporting data as a CSV file from Unix shell script

Shell Programming and Scripting
1

Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.

Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?

The following sample data is saved as a .csv file in the shared folder for the end user.Is there a way,i could present the header alone with different fonts/color to the end user.(FYI,the end user will access the csv file using microsoft excel)

Header:

LOCATION,ATM-ID,REPLENISHED DAY,50,100,500,TOTAL REPLENISHED,50,100,500,TOTAL DISPENSED,UTILIZATION %,50,100,500,TOTAL CASH AVAILABLE,AVAILABLE CASH %

Data:

XXXX ,12345,23/04/2010,25000,100000,250000,375000,8800,51100,90500,150400,40.11%,16200,48900,159500,224600,59.89%
YYYY ,67890,23/04/2010,25000,100000,250000,375000,2150,13100,36000,51250,13.67%,22850,86900,214000,323750,86.33%
2

I would do the colour formating in Excel not the shell script. If the formating and columns are always the same then record a macro in Excel to import the data and format the columns.

3

Thanks steadyonabix ...i was just curious if it can be done through Unix shell scripting...because this can be done through C++.
I ve created a macro in XLS and is getting the output as desired.