Column headers in CSV file for excel
 

I have a c# windows form that is using steam writer that is writing rows from
a database instead of a dataset to a CSV file but when I open it in excel
10.0 the Column headers are just the letters. Is there any way to write in
csv so as to rename the column headers?

If not I can write to column headers to the the first row can that be used
in anyway for analysis or would it be useless?

Conor.

Column headers in CSV file for excel
 

All CSV is the actual data witth commar to seperate the data into
diffferentt columns in Excel. I would open the CSV file with notepad and see
whatt datta is actually in the file to determine if the problem is in writing
the data or excel reading tthe data.

Make sure the CR/LF is put in the CSV file.

"OceanMist" wrote:

I have a c# windows form that is using steam writer that is writing rows from
a database instead of a dataset to a CSV file but when I open it in excel
10.0 the Column headers are just the letters. Is there any way to write in
csv so as to rename the column headers?

If not I can write to column headers to the the first row can that be used
in anyway for analysis or would it be useless?

Conor.