Use CloudConnector for Excel to call Wolfram APIs from within spreadsheets.

Install Wolfram CloudConnector for Excel

Install the CloudConnector for Excel plugin by following the instructions in Setup and Getting Started.

Create the API

In your Wolfram desktop product, use APIFunction to create a function that returns all the business days from a specified date and range of days:

Deploy the API

Use CloudDeploy to send the API to the Wolfram Cloud:

Call the APIFunction in Excel

In Excel, use the WolframAPI function to call your deployed API:

  • When calling a deployed API, specify everything after https://wolframcloud.com/obj.