Loop over Generic List of Lists and write in csv format (C#)

Question

i want to save the result of my List to be save as csv into a variable path with encoding UTF.

But when i loop with foreach over my list:

    foreach (String item in finalausgabe)
            {
                Console.WriteLine(ausgabe.GetType());
            }

i get the following result in my Console (just the first five lines for preview)

System.Collections.Generic.List1[System.String]
System.Collections.Generic.List1[System.String]
System.Collections.Generic.List1[System.String]
System.Collections.Generic.List1[System.String]
System.Collections.Generic.List1[System.String]

But my list looks actually like this:

"STATUS" "USERID" "Username" "Vorname" "Nachname" "Zweiter Vorname"
"active" "1" "testm" "test" "M" "" "M" "" "Kuhnkies" "active" "10" "lext" Sofia Daasch "" "F" "" "Lex" "active" "102" "reiterr" Anna Dabbagh "" "M" "" "Reiter" "active" "103" "buchmeiera" Lea Dabbert "" "M" "" "Buchmeier" "active" "104" "fuchss" Emilia Dabels "" "M" ""

as you can see its already prepared as a tab separated csv, just needs to be saved line by line in csv-file with encoding "utf-8".

What do you think `.GetType()` does – mjwills Feb 14 '18 at 08:36 — mjwills, Feb 14 '18 at 08:36
gets my the type.. got it, but .GetValue() doesnt work.. – kb9992 Feb 14 '18 at 08:38 — kb9992, Feb 14 '18 at 08:38

score 0 · Answer 1 · answered Feb 14 '18 at 08:38

0

well obviously you should write something like

foreach (String item in finalausgabe)
            {
                Console.WriteLine(item);
            }

answered Feb 14 '18 at 08:38

Levanan Gan

51
4

thanks, this works! but how to save it now line by line in a csv with encoding "utf-8" – kb9992 Feb 14 '18 at 08:41
https://stackoverflow.com/questions/14057434/how-can-i-transform-string-to-utf-8-in-c – Levanan Gan Feb 14 '18 at 08:53

Ali Ezzat Odeh · Answer 2 · 2018-02-14T11:15:29.710

I suggest using CsvHelper, and order your data in a insetead of making your data as separate strings, for example:

class MyRecord
{
    public string Status {get; set;}
    public string UserId {get; set;}
    public string UserName {get; set;}
}

then use the CsvHelper as the following:

List<MyRecord> records = yourFilledList;
var textWriter = new StreamWriter("your file path",isAppend, Encoding.UTF8);
var csv = new CsvWriter( textWriter );
csv.WriteRecords( records );

and as for the foreach the item will be available for you automatically in each iteration so you should use it directly, it follows

Console.WriteLine(element);

for more info about CsvHelper and how to install nuget check this.

Loop over Generic List of Lists and write in csv format (C#)

2 Answers2