CsvHelper Ignore case for header names

Question

I have some class

public class Import
{
    public DateTime Date { get; set; }
    public string Category { get; set; }
}

In csv file header names can be in lowercase. How I can ignore case while reading file?

    var reader = new StreamReader(@"///");
    var csv = new CsvReader(reader);
           
    var records = csv.GetRecords<Import>().ToList();

Answer 1

If you are using the http://joshclose.github.io/CsvHelper/ you can provide some configuration when constructing the CsvReader or configuring it after construction.

    using (var stringReader = new StringReader(yourString))
    using (var csvReader = new CsvReader(stringReader))
    {
        // Ignore header case.
        csvReader.Configuration.PrepareHeaderForMatch =  (string header, int index) => header.ToLower();
        return csvReader.GetRecords<Import>().ToList();
    }

There is more documentation in the PrepareHeaderForMatch section at https://joshclose.github.io/CsvHelper/api/CsvHelper.Configuration/Configuration/

For more granularity there are also class mapping instructions for which can be found under here: https://joshclose.github.io/CsvHelper/examples/configuration

Hope that helps.