Posted By: Anonymous
Is there a default/official/recommended way to parse CSV files in C#? I don’t want to roll my own parser.
Also, I’ve seen instances of people using ODBC/OLE DB to read CSV via the Text driver, and a lot of people discourage this due to its “drawbacks.” What are these drawbacks?
Ideally, I’m looking for a way through which I can read the CSV by column name, using the first record as the header / field names. Some of the answers given are correct but work to basically deserialize the file into classes.
Let a library handle all the nitty-gritty details for you! 🙂
Check out FileHelpers and stay DRY – Don’t Repeat Yourself – no need to re-invent the wheel a gazillionth time….
You basically just need to define that shape of your data – the fields in your individual line in the CSV – by means of a public class (and so well-thought out attributes like default values, replacements for NULL values and so forth), point the FileHelpers engine at a file, and bingo – you get back all the entries from that file. One simple operation – great performance!