DSXchange

Hi
I am moving some table data into a .csv file or .xls file using datastage. Just want to have the column names in that .csv file or .xls file cells in high lighted colour. Can you do it with some transforer stage with colour code ?

A B C D <-------column names or those spread sheet cells in high lighted color
1 2 3 4 <------from here data in normal style
2 2 3 4
2 2 3 4
2 2 3 4



Any ideas please

Thanks
RK

You cannot format in a csv.

In an xls, you can use macro during open.

Alternatively you can create the header seperately - as a one off activity - and append the detail with the header.