How to open and read .csv file and store as array

C# Corner

solya merto

11y8.5kVisual Basic .NET

Hello,

I am new to C# , how can I open and read .csv file and store it as an array in Console application using c#.

thanks .

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

solya merto11y ago
Thanks Rajeesh . I did like that but the .csv file I want to open have 36 columns , I need something like loop statement , how can I use loop statement .

Rajeesh Menoth11y ago

Hi,

using System.IO;

static void Main(string[] args)
{
    var reader = new StreamReader(File.OpenRead(@"C:\test.csv"));
    List listA = new List();
    List listB = new List();
    while (!reader.EndOfStream)
    {
        var line = reader.ReadLine();
        var values = line.Split(';');

        listA.Add(values[0]);
        listB.Add(values[1]);
    }
}

Reference : http://stackoverflow.com/questions/5282999/reading-csv-file-and-storing-values-into-an-array