How to create own API to convert XML file to JSON

[Prajwal Deep Bhandari]

Right now we are opening XML through this openURL "https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/open" but we want to make our own API to get WORKBOOK from C# web API. Is it possible to make own API, if it is than please can you help us out?

[Madhan Venkateshan]

Hi Prajwal Deep Bhandari, 

 

Good day to you. 

 

Yes, you can use your own API for opening excel by using ‘Syncfusion.EJ2.Spreadsheet.AspNet.Core’ package, we have prepared an API service for your requirement, please refer the below code snippets and service link. 

 

[Route("api/[controller]")] 

    [ApiController] 

    public class SpreadsheetController : ControllerBase 

    { 

        [HttpPost] 

        [Route("Open")] 

        public IActionResult Open(IFormCollection openRequest) 

        { 

            OpenRequest open = new OpenRequest(); 

            open.File = openRequest.Files[0]; 

            return Content(Workbook.Open(open)); 

        } 

    } 

 

 

Service link: https://www.syncfusion.com/downloads/support/forum/155944/ze/SpreadsheetWebAPI685462434 

 

Documentation link: https://ej2.syncfusion.com/aspnetcore/documentation/spreadsheet/open-save/ 

 

Regards, 

Madhan V 

[Christian]

I have a question, there is a way to  create my own API but with Java

[Aravinthan Seetharaman]

Hi Christian, 

 

We have checked your query. And we would like to let you know that we don’t have support that JAVA as backend service for import/export action. And we are using the XLSIO library for open/save action and we have already logged the feedback for this support. Please find the link below.  

 

https://www.syncfusion.com/feedback/13225/xlsio-java-library 

 

Regards, 

Aravinthan S