Reading a CSV file in .NET?

by

A choice, without using third-party components, is to use the class Microsoft.VisualBasic.FileIO.TextFieldParser (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.aspx) . It provides all the functions for parsing CSV. It is sufficient to import the Microsoft.VisualBasic assembly.

var parser = new Microsoft.VisualBasic.FileIO.TextFieldParser(file);
parser.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited;
parser.SetDelimiters(new string[] { ";" });

while (!parser.EndOfData)
{
    string[] row = parser.ReadFields();
    /* do something */
}

More Related Contents:

  1. How to read a CSV file into a .NET Datatable
  2. How to split csv whose columns may contain ,
  3. Reading CSV file and storing values into an array
  4. Headless browser for C# (.NET)? [closed]
  5. How to set a proxy for Webbrowser Control without effecting the SYSTEM/IE proxy
  6. Using C# to search a CSV file and pull the value in the column next to it
  7. Setting a cookie in a WebBrowser control
  8. WebClient runs javascript
  9. How to split csv whose columns may contain comma
  10. Writing a CSV file in .net
  11. Why is WebBrowser_DocumentCompleted() firing twice?
  12. Upload CSV file to SQL server
  13. Is there a “proper” way to read CSV files [duplicate]
  14. Does any one know of a faster method to do String.Split()?
  15. Writing a Header using CsvHelper? C#
  16. regex to split line (csv file)
  17. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  18. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  19. No output to console from a WPF application?
  20. C# dictionary – one key, many values
  21. Two-way / bidirectional Dictionary in C#?
  22. Weak event handler model for use with lambdas
  23. Is there Windows system event on active window changed?
  24. Discovering derived types using reflection
  25. How to read a .NET Guid into a Java UUID
  26. System.Net.WebClient unreasonably slow
  27. Using HashSet in C# 2.0, compatible with 3.5
  28. How do I tell if a type is a “simple” type? i.e. holds a single value
  29. .net connection pooling
  30. Repository Pattern, POCO, and Business Entities

Leave a Comment