Setup and Getting Started
|Setup for Excel Users||Setup for Administrators (Wolfram Enterprise Private Cloud)|
|Setup for Developers|
Wolfram CloudConnector for Excel is a plugin in Excel that calls a Wolfram Cloud through the web. This tutorial is divided into sections that outline the installation process for Excel users and developers. If you are using an Enterprise Private Cloud (EPC), an administrator can install extra tools to aid development.
For CloudConnector for Excel to work, you must download and install the plugin. A link to this can be found on the CloudConnector link.
Once it is installed, you will have direct access to the plugin within Excel, but you may need to change some preference settings for correct operation with a Wolfram Cloud. These settings can be changed by clicking the Wolfram tab and clicking the Preferences button. The most important settings are the Cloud Base and the Default Cloud Account.
The Default Cloud Account avoids the need to specify the cloud account in each Wolfram API call. It is useful if the majority of your APIs are from a single account. However, it can be left unset, in which case the cloud account must be given for each call. See Calling Wolfram APIs > API Name for more details.
See the Preferences section for more information.
Using the Wolfram function requires you to be signed into the Wolfram Cloud. Additionally, some Wolfram APIs require you to be signed in for access. Signing in requires a cloud account. You can sign in by clicking the "Signed Out" button in the Wolfram tab.
See the Cloud Accounts section for more information.
If this API has been successful, the result should show 65 in the cell. If you are connecting to an EPC, it is possible that this API has not been installed and therefore will not work correctly. Your administrator will tell you if the examples have been installed.
See the Example Wolfram APIs section for more examples.
Before using this section, please follow the instructions in the Setup for Excel Users section, which contains setup instructions for the CloudConnector for Excel plugin.
You will need a Cloud Account to be able to deploy Wolfram APIs.
To deploy a Wolfram API from a Cloud notebook, you can use a web browser to sign into a Wolfram Cloud. Then open a Cloud notebook, and you should be able to deploy APIs to the Wolfram Cloud you are signed into.
Most features of the CloudConnector work without any changes to your cloud account. However, the Insert API Call feature requires deployment of an API. This API is secure and only returns parameter names and their interpreter types of a given API.
Once deployed, this API will live on your cloud account with the name "MyFirstAPIFunction". You can test correct operation through the URLRead function:
There is a Configuration notebook for administrators of Wolfram Enterprise Private Cloud. The only function of the Configuration notebook is to create a documentation account and install a number of Wolfram APIs under this account. These are the APIs used in the Example Wolfram APIs section. If this setup is not carried out, the Cloud Connector for Excel will function properly, however, users will not be able to verify its operation and follow the documentation.
Typically, the Configuration notebook can be downloaded from the Cloud Connector for Excel resources page.
Enter the URL https://www.mywolframcloud.com/objects/Documentation/Example/AddTwo?x=10&y=20, and a value of 30 should be returned. Note that the correct cloud base and cloud account for the installation should be used.