Reading .csv file line by line

Question

I have an excel file (.csv) which I want to read line by line or to be more precise row by row and get it stored in a string in C# Any help is appreciated .

I suggest you do a search on SO as this has been answered many times. — Sorceri, Dec 02 '13 at 15:48
A CSV is just a comma-delimited text file if that makes it easier to figure out what to do. ([hint](http://stackoverflow.com/questions/15560011/how-to-read-a-csv-file-one-line-at-a-time-and-parse-out-keywords)) — D Stanley, Dec 02 '13 at 15:48
@fOcusWow SO = Stack Overflow (see [What do SO, SF and SU stand for?](http://meta.stackexchange.com/a/114549/167646)) — user247702, Dec 02 '13 at 15:50
Pro tip: On pretty much any internet community, posting without using the search function will always result in a firestorm and down-votes where applicable. Stack Overflow even suggests related questions when you create one! — Gusdor, Dec 02 '13 at 15:51

Alexander Forbes-Reed · Accepted Answer · 2017-10-25T09:49:42.393

7

This should have your back;

var csvRows = File.ReadAllLines(@"C:\demo.csv");

It loads each line into a new entry in a string array. (Provided that the file's EOL char is \r\n, and not just \n)

edited Oct 25 '17 at 09:49

answered Dec 02 '13 at 15:48

Alexander Forbes-Reed

2,823
4
27
44

Sudhakar Tillapudi · Answer 2 · 2013-12-02T15:54:36.473

5

You can use System.IO.File.ReadAllLines() function to Read all the Lines from the given filepath.

Syntax : String [] lines= System.IO.File.ReadAllLines(String filepath)

Try This:

string path = @"C:\filename.csv";
String [] allLines=System.IO.File.ReadAllLines(path);

edited Dec 02 '13 at 15:54

answered Dec 02 '13 at 15:49

Sudhakar Tillapudi

25,935
5
37
67

score 0 · Answer 3 · edited Dec 02 '13 at 16:01

Below snippet may be helpful for you. Have a look.

            TextFieldParser parser = new TextFieldParser(@"D:\test.csv");
            parser.TextFieldType = FieldType.Delimited;
            parser.SetDelimiters(",");
            while (!parser.EndOfData)
            {
                //Processing row
                string[] fields = parser.ReadFields();
                foreach (string field in fields)
                {
                    string test =field;
                }
            }
            parser.Close();

include Microsoft.VisualBasic as a reference.

Reading .csv file line by line

3 Answers3