Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
Hide Column Headers but not row (Headers) | Excel Programming | |||
Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
Excel column/row headers | Excel Worksheet Functions | |||
Excel Column Headers | Excel Discussion (Misc queries) |