Have you ever wanted to turn your Excel spreadsheets into a web service or REST API? AlchemyJ allows you to turn excel to API easily.
The above video shows you step by step on how you can utilize AlchemyJ to turn a spreadsheet calculating Body Mass Index (BMI) on Excel to API at the same time provide the OpenAPI documentation.
You do not need to know how to code or program to follow along with the tutorial. After we build an API from Excel, we can test it on an OpenAPI webpage (Swagger) which describes the API.
The REST API call returns JSON data and it can be used in web apps, web pages, web sites, JAVA projects, and in any languages that support web service calls. It supports HTTP methods such as GET, POST, PUT, and DELETE. With AlchemyJ, you can convert your Excel workbook to a custom web API.
Stay tuned for our next post.