Loading

Creating Word/Excel Doc from Json string

Rameez Javed

Hi, I hope everybody is doing well here, I want to create a word doc from json string, can anybody guide me in this regard. I'm getting json response from application and want to create word or excel file from that json data.

Thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
1. [{
2. "foo": "bar"
3. }]
4. With Json.NET we can do the following to get it into C#
6. var jsonData = "[{ \"foo\": \"bar\" }]";
8. var jsonDefinition = new object[]
9. {
10. new {foo = ""}
11. };
13. var result = JsonConvert.DeserializeAnonymousType(jsonData, jsonDefinition);
14. We can then loop through the structure, outputting to a CSV file.
16. var sb = new StringBuilder();
17. foreach (dynamic o in result)
18. {
19. sb.AppendLine(o.foo);
20. }
21. File.WriteAllText(@"c:\code\test.csv", sb.ToString());
+1