Very simple C# CSV reader

by

You can try the some thing like the below LINQ snippet.

string[] allLines = File.ReadAllLines(@"E:\Temp\data.csv");

    var query = from line in allLines
                let data = line.Split(',')
                select new
                {
                    Device = data[0],
                    SignalStrength = data[1],
                    Location = data[2], 
                    Time = data[3],
                    Age = Convert.ToInt16(data[4])
                };

UPDATE: Over a period of time, things evolved. As of now, I would prefer to use this library http://www.aspnetperformance.com/post/LINQ-to-CSV-library.aspx

More Related Contents:

  1. How to have nested query with LINQ
  2. Read a CSV to a C# object to be able to do LINQ query on it [closed]
  3. Search column name in csv file using c# [closed]
  4. Unable to read from a CSV using List
  5. Parsing CSV files in C#, with header
  6. Reading CSV files using C#
  7. How to read a CSV file into a .NET Datatable
  8. How to split csv whose columns may contain ,
  9. Reading CSV file and storing values into an array
  10. Are there any CSV readers/writer libraries in C#? [closed]
  11. Reading a CSV file in .NET?
  12. C#, regular expressions : how to parse comma-separated values, where some values might be quoted strings themselves containing commas
  13. Reading CSV files in C# [closed]
  14. Is there any simple way to convert .xls file to .csv file? (Excel)
  15. How to create CSV Excel file C#? [closed]
  16. JSON string to CSV and CSV to JSON conversion in c#
  17. Sending an array of values to Oracle procedure to use in WHERE IN clause
  18. OpenFileDialog can’t load CSV files but can load xls/xlsx Excel files [duplicate]
  19. Using C# to search a CSV file and pull the value in the column next to it
  20. Reading Data from CSV to Screen output [closed]
  21. Importing CSV data into C# classes
  22. Writing a CSV file in .net
  23. Is csv with multi tabs/sheet possible?
  24. CSV to object model mapping
  25. Upload CSV file to SQL server
  26. how to read a csv file from a url?
  27. Writing a Header using CsvHelper? C#
  28. Fastest way to convert a list of objects to csv with each object values in a new line
  29. Converting a csv file to json using C#
  30. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?

Leave a Comment