How to generate excel format using json data in web API

Question

I was trying to find a solution convert json data to excel in web API. Pelase help through simple example in web api

Madan Shekar · Answer

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); } } } https://www.grapecity.com/blogs/how-to-generate-excel-from-xml-and-json-data-using-c

How to generate excel format using json data in web API

Answers (1)