CsvHelper getting just the headers row

Question

I am trying to read an uploaded CSV file and before doing anything with the data I need to check the first header name to be sure it is the correct file. I have been trying to find a way to do it but the reader skips to the second row instead. Is there a direct way of selecting one of the headers and checking its value?

Answer 1

You can use the CsvReader to get the header row strings as described in this answer:

using (var csv = new CsvReader(reader))
{
    csv.Read();
    csv.ReadHeader();
    string[] headerRow = csv.Context.HeaderRecord;
}

Answer 2

You can use the parser directly if you want to just check the first row.

var parser = new CsvParser( textReader );
var row = parser.Read();
if( row[0] == "MyColumn" ) { /* do something */ }

If you're using a Stream, you will need to reset it to the beginning if you're going to use it again.