Converting a csv file to json using C#

by

If you can use System.Web.Extensions, something like this could work:

var csv = new List<string[]>(); // or, List<YourClass>
var lines = System.IO.File.ReadAllLines(@"C:\file.txt");
foreach (string line in lines)
    csv.Add(line.Split(',')); // or, populate YourClass          
string json = new 
    System.Web.Script.Serialization.JavaScriptSerializer().Serialize(csv);

You might have more complex parsing requirements for the csv file and you might have a class that encapsulates the data from one line, but the point is that you can serialize to JSON with one line of code once you have a Collection of lines.

More Related Contents:

  1. JSON string to CSV and CSV to JSON conversion in c#
  2. Create a strongly typed c# object from json object with ID as the name
  3. Convert JSON String To C# Object
  4. CSV parser/reader for C#? [closed]
  5. JSON.Net throws StackOverflowException when using [JsonConvert()]
  6. How to parse huge JSON file as stream in Json.NET?
  7. Unexpected character encountered while parsing value
  8. json deserialization to C# with dynamic keys [duplicate]
  9. Parsing JSON Object with variable properties into strongly typed object
  10. Order of serialized fields using JSON.NET
  11. Json.NET serialize object with root name
  12. Set default global json serializer settings
  13. Generically Flatten Json using c#
  14. How to turn off or handle camelCasing in JSON response ASP.NET Core?
  15. Why are some members missing when trying to print an object by serializing to JSON?
  16. Convert object to JSON string in C# [duplicate]
  17. How to apply indenting serialization only to some properties?
  18. How to apply ObjectCreationHandling.Replace to selected properties when deserializing JSON?
  19. What is the simplest C# function to parse a JSON string into an object? [closed]
  20. Return JSON with error status code MVC
  21. Deserialize json object with dynamic items in C#
  22. Can JavaScriptSerializer exclude properties with null/default values?
  23. JSON.NET serialize JObject while ignoring null properties
  24. Post JSON array to mvc controller
  25. JSON.Net Xml Serialization misunderstands arrays
  26. Remove empty string properties from json serialized object
  27. Configure Json.NET serialization settings on a class level
  28. System.Text.Json: How to apply a JsonConverter for a collection with a custom converter for the collection’s items?
  29. deserialize part of json string (array) in c#
  30. JSON.NET Serializes Empty JSON

Leave a Comment