Column headers in CSV file for excel

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Header to CSV 9
convert columns to rows 6
CSV file losing "#" in column headers 1
Find Specific Rows in Range and Create New Tab 18
Changing a csv file opened as hidden workbook 13
How do I sum a column based on 2 different column headers/criteria? 0
Adding a header to a CSV file 4
Starting Word from Excel 2

Top