Convert Excel Workbook to REST API (Web service)

Turn your Excel spreadsheets into a web service, REST API with AlchemyJ. In this video, we will show you the basics on how to turn a Body Mass Index (BMI) calculator in Excel into a REST API with OpenAPI documentation. It requires no code and no programming experience. After we build an API from Excel, we can test it on an OpenAPI webpage (Swagger) which describes the API.

The Excel REST API call returns JSON data. It can be used in web apps, web pages, web sites, Java projects and in any language 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.

Download a free copy of AlchemyJ Community Edition:

Getting started with AlchemyJ

#AlchemyJ #Excel #RESTAPI

[rasoulkhoshravan]

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.

[rjnaughton]

Does AlchemyJ support/convert vba code?

[abrotherinchrist]

I would like to see some examples of this in action from Excel all the way to a website, perhaps with some Wordpress plugins like WooCommerce.

[fakeproducer]

Hi, great video. Does AlchemyJ support using named ranges as opposed to the actual cell reference?

[TimothyTrapanotto]

i tried to download it for free - and it sent me to a contact page - when I sent in my info - I got a quote for $9000 - so apparently there is no free edition....

[zohairahmed]

Hi, I like your video but when I implement it than it gives me error that you may not select more than two rows.. I want to make an api of excel sheet in which there is a number of rows and columns and then I will fetch it into my website .

[uttammalhotra]

Nice job! But I'm having this error below while using in my company laptop, I tried after setup HTTP system variable to pass proxy server with my user id and password. Please advice if you know about this errror

[ERROR] - Failed to execute command: [C:\My Data\AlchemyJ\AlchemyJ Community Edition\AlchemyJ Compiler\resource\apache-maven-3.6.1\bin\mvn.cmd, -s, "C:\My Data\AlchemyJ\AlchemyJ Community Edition\AlchemyJ Compiler\resource\apache-maven-3.6.1\conf\settings.xml", clean]