PC Review


Reply
Thread Tools Rate Thread

Column headers in CSV file for excel

 
 
=?Utf-8?B?T2NlYW5NaXN0?=
Guest
Posts: n/a
 
      8th Aug 2007
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 With Quote
 
 
 
 
=?Utf-8?B?Sm9lbA==?=
Guest
Posts: n/a
 
      8th Aug 2007

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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - returning column headers in a seperate column =?Utf-8?B?RXhjZWxDb25mdXNlZA==?= Microsoft Excel Misc 1 28th Mar 2006 02:49 PM
Excel column/row headers =?Utf-8?B?bWR1Y2t3b3J0aDc3?= Microsoft Excel Worksheet Functions 2 22nd Mar 2005 11:29 PM
Excel Column Headers =?Utf-8?B?bXVnZ2ludA==?= Microsoft Excel Misc 4 22nd Feb 2005 01:23 PM
Excel column headers 1234 Microsoft Excel Worksheet Functions 1 26th Jan 2004 04:24 PM
Re: Excel column headers Ken Wright Microsoft Excel Worksheet Functions 0 18th Jul 2003 06:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:40 AM.