Issue getting cell value from CSV file using CsvHelper

Question

using (var sr = new StreamReader("myfile.csv"))
{
    var reader = new CsvReader(sr);
    List<dynamic> csvRecords = reader.GetRecords<dynamic>().ToList();

    //this works
    foreach (var row in csvRecords)
    {
        foreach (var item in row)
        {
            var z = item.Value;
        }
    }

    //this should work, error message below
    foreach (var row in csvRecords)
    {
        var z = row[0].Value;
    }
}

ERROR

Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot apply indexing with [] to an expression of type 'System.Dynamic.ExpandoObject

please actually describe your issue, what you tried, and where it went wrong. — Adam B, Jun 22 '18 at 06:06

score 1 · Accepted Answer · edited Oct 24 '22 at 17:51

According to documentation you can get fields using Read()

using (var reader = new StreamReader("myfile.csv")) {
    var csv = new CsvReader( reader );
    while(csv.Read()) {//This will advance the reader to the next record.
    
        //You can use an indexer to get by position or name. 
        //This will return the field as a string

        // By position
        var field = csv[0];

        // By header name
        var field = csv["HeaderName"];
    }
}

Reference https://joshclose.github.io/CsvHelper/reading#getting-fields

d_f · Answer 2 · 2018-06-22T13:22:36.180

Your row implements IDictionary<String, object> interface explicitly, so to get the value, you have to cast the row instance first, and then to use ElementAt(0).Value, or to address the value by its column name:

//this works fine
foreach (IDictionary<string, object> row in csvRecords)
{
     var z = row["column name"];
}

//and this works too 
foreach (IDictionary<string, object> row in csvRecords)
{
      var z = row.ElementAt(0).Value;
}

Issue getting cell value from CSV file using CsvHelper

2 Answers2

Linked