How to generate excel format using json data in web API

private void GetExcel_Click(object sender, EventArgs e)
{
GenerateFromJSON(apiurl);
}
string apiurl = "http://demos.componentone.com/ASPNET/C1WebAPIService/api/excel"; //web api demo url
public void GenerateFromJSON(string webapiurl)
{
var url = "http://services.odata.org/V4/Northwind/Northwind.svc/Products?$format=json"; //get products from ODATA service
using (var clientjs = new HttpClient())
{
HttpResponseMessage responseJSON = clientjs.GetAsync(url).Result;
responseJSON.EnsureSuccessStatusCode();
var responseBody = responseJSON.Content.ReadAsStringAsync().Result; //Get JSON from ODATA service
var data = JsonConvert.DeserializeObject(responseBody)["value"]; //use JsonConvert to deserialize raw json
using (var client = new HttpClient())
using (var formData = new MultipartFormDataContent())
{
var fileFormat = "xlsx";
formData.Add(new StringContent("Test"), "FileName");
formData.Add(new StringContent(fileFormat), "FileFormat");
formData.Add(new StringContent(JsonConvert.SerializeObject(data)), "Data");
//Call WebAPI to get Excel
var response = client.PostAsync(webapiurl, formData).Result;
if (!response.IsSuccessStatusCode)
{
MessageBox.Show("Invalid response.");
return;
}
var tempPath = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString());
if (!Directory.Exists(tempPath))
{
Directory.CreateDirectory(tempPath);
}
//Save Excel to Tem directory.
var tempFilePath = Path.Combine(tempPath, string.Format("{0}.{1}", "Test", fileFormat));
using (var newFile = File.Create(tempFilePath))
{
response.Content.ReadAsStreamAsync().Result.CopyTo(newFile);
}
//Open Excel to view.
Process.Start(tempFilePath);
}
}
}

1 Reply

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

Madan Shekar7y ago
1. private void GetExcel_Click(object sender, EventArgs e)
2. {
3. GenerateFromJSON(apiurl);
4. }
5. string apiurl = "http://demos.componentone.com/ASPNET/C1WebAPIService/api/excel"; //web api demo url
6. public void GenerateFromJSON(string webapiurl)
7. {
8. var url = "http://services.odata.org/V4/Northwind/Northwind.svc/Products?$format=json"; //get products from ODATA service
9. using (var clientjs = new HttpClient())
10. {
11. HttpResponseMessage responseJSON = clientjs.GetAsync(url).Result;
12. responseJSON.EnsureSuccessStatusCode();
13. var responseBody = responseJSON.Content.ReadAsStringAsync().Result; //Get JSON from ODATA service
14. var data = JsonConvert.DeserializeObject(responseBody)["value"]; //use JsonConvert to deserialize raw json
15. using (var client = new HttpClient())
16. using (var formData = new MultipartFormDataContent())
17. {
18. var fileFormat = "xlsx";
19. formData.Add(new StringContent("Test"), "FileName");
20. formData.Add(new StringContent(fileFormat), "FileFormat");
21. formData.Add(new StringContent(JsonConvert.SerializeObject(data)), "Data");
22. //Call WebAPI to get Excel
23. var response = client.PostAsync(webapiurl, formData).Result;
24. if (!response.IsSuccessStatusCode)
25. {
26. MessageBox.Show("Invalid response.");
27. return;
28. }
29. var tempPath = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString());
30. if (!Directory.Exists(tempPath))
31. {
32. Directory.CreateDirectory(tempPath);
33. }
34. //Save Excel to Tem directory.
35. var tempFilePath = Path.Combine(tempPath, string.Format("{0}.{1}", "Test", fileFormat));
36. using (var newFile = File.Create(tempFilePath))
37. {
38. response.Content.ReadAsStreamAsync().Result.CopyTo(newFile);
39. }
40. //Open Excel to view.
41. Process.Start(tempFilePath);
42. }
43. }
44. }
https://www.grapecity.com/blogs/how-to-generate-excel-from-xml-and-json-data-using-c
0