How to convert .json file to excel in C #

Question

I want to convert a .json file to excel. iam cannot find a solution anywhere for this problem using C # language. Can anyone help me with them along with the exact solution.

Answer 1

Here is another partial solution that does not require json if json is in table format.

DataTable dt = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));

Here you can use any of the many datatable → excel solutions available on the Internet.

Many are published here: How to Export a DataTable to Excel

Answer 2

, Excel. Json.NET CSV , Excel.

JSON...

[{
    "foo": "bar"
}]

Json.NET , #

var jsonData = "[{ \"foo\": \"bar\" }]";

var jsonDefinition = new object[]
{
    new {foo = ""}
};

var result = JsonConvert.DeserializeAnonymousType(jsonData, jsonDefinition);

, CSV.

var sb = new StringBuilder();
foreach (dynamic o in result)
{
    sb.AppendLine(o.foo);
}
File.WriteAllText(@"c:\code\test.csv", sb.ToString());