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.
This is my first time watching for such video. So really writing a REST API to calculate such a simple calculation in the web, requires so many steps? Working in this field requires lots of knowledge. Thanks to Leila Gharani that introduced AlchemyJ in one of her videos.