Adding headers into CSV output file using StreamWriter

Question

I am trying to add headers into the CSV file and as a headers I would like to have the variables names used in the WriteLine.

Here you have my code:

using (StreamWriter file = new StreamWriter(fs))                    
{
    for (int s = 0; s < pr.Length; ++s)
    {
        string[] UsersIDS = new string[] {""};
        UsersIDS = db.GetUsersList(pr[s].ProjectID);
        file.WriteLine(
             pr[s].ProjectID + '"' + ',' + 
             '"' +  pr[s].ProjectTitle + '"' + ',' + 
             pr[s].PublishStatus + '"' + ',' + 
             UsersIDS.Length); 
    }
}

header for the CSV is on the first line. so just do a writeline just after creating the File. Header1,Header2,.. and then start writing data for every line representing each row — sumeet kumar
– sumeet kumar, Commented Sep 2, 2015 at 15:31
So this code is printing out each line in the CSV? You want the header first? Just call file.Writeline before the for loop with whatever you want in header? — Andy Wiesendanger
– Andy Wiesendanger, Commented Sep 2, 2015 at 15:31
@YuraZaletskyy the variable pr its an array from the web service call that has been initialized before. the csv file is correct but it does not include headers, so I am trying to include them, thanks — A arancibia
– A arancibia, Commented Sep 2, 2015 at 15:38
Hi @AndyWiesendanger yes the file gets the output requested but I am stuck including for each column a header — A arancibia
– A arancibia, Commented Sep 2, 2015 at 15:41

Yuriy Zaletskyy · Accepted Answer · 2015-09-02 15:43:29Z

3

I propose you following modification

using (StreamWriter file = new StreamWriter(fs))                    
{
    file.WriteLine("ProjectID, ProjectTitle,PublishStatus,Length");
    for (int s = 0; s < pr.Length; ++s)
    {
        string[] UsersIDS = new string[] {""};
        UsersIDS = db.GetUsersList(pr[s].ProjectID);
        file.WriteLine( pr[s].ProjectID + '"' + ',' + '"' + pr[s].ProjectTitle + '"' + ',' + pr[s].PublishStatus + '"' + ',' + UsersIDS.Length); 

}//end of for

answered Sep 2, 2015 at 15:43

Yuriy Zaletskyy

5,1695 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexei Levenkov · Accepted Answer · 2015-09-02 15:41:23Z

2

Just regular WriteLine with constant string seem to be what you are after (unless you want to get names of columns via reflection or some other way):

using (StreamWriter file = new StreamWriter(fs))                    
{
    file.WriteLine( "ProjectID,ProjectTitle,PublishStatus,UsersIDS_Length"); 

    for (int index = 0; index < pr.Length; index++)
    {
        var usersIds = db.GetUsersList(pr[s].ProjectID);
        file.WriteLine("{0},\"{1}\",{2},{3}",
           pr[s].ProjectID, pr[s].ProjectTitle,
           pr[s].PublishStatus, usersIds.Length); 
    }
}

(Sound like you also wanted quotes around title... the rest of quotes looked unbalanced).

answered Sep 2, 2015 at 15:41

Alexei Levenkov

101k15 gold badges138 silver badges189 bronze badges

1 Comment

A arancibia Over a year ago

Hi, I just tested the suggested modification and its very neat! Sorry I haven't tested correctly before. I really like this one! thanks

Collectives™ on Stack Overflow

Adding headers into CSV output file using StreamWriter

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related