CSVHelper how to map a string to object

Question

I have a string in a variable, rather than in a file.

Can I use the CSVHelper (https://joshclose.github.io/CsvHelper/) to parse the string and map it onto my object?

The code to map a CSV file works:

TextReader reader = new StreamReader("data.csv"); var csvReader = new CsvReader(reader); var records = csvReader.GetRecords<CarModel>();

How can I change that to map a string to the object:

String carmodels "make,model,year\n\rFord,Escort,1998\n\rHonda,Civic,1994"; TextReader reader = new StreamReader(carmodels); var csvReader = new CsvReader(reader); var records = csvReader.GetRecords<CarModel>();

Thanks for any help,

Mark

Possible duplicate of In C#, how can I create a TextReader object from a string (without writing to disk) — Matt.G
– Matt.G, Commented Mar 22, 2019 at 16:18

Joel Coehoorn · Accepted Answer · 2023-01-11 21:43:21Z

Assuming the CarModel type is already mapped correctly, you can use a StringReader rather than a StreamReader:

string carmodels = "make,model,year\n\rFord,Escort,1998\n\rHonda,Civic,1994"; using (var reader = new StringReader(carmodels)) using (var csvReader = new CsvReader(reader)) { var records = csvReader.GetRecords<CarModel>(); }

CsvReader(reader, CultureInfo.InvariantCulture) for the new version.

Stejin · Accepted Answer · 2019-03-22 16:34:06Z

You "need" to setup a mapping for your class, so it know's which column goes to which property. Even the .AutoMap() can work for you. https://joshclose.github.io/CsvHelper/examples/configuration/class-maps/auto-mapping/

Collectives™ on Stack Overflow

CSVHelper how to map a string to object

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related