Cloud Connector for Excel

Anthony Zupnik, Wolfram Research

Join the Conversation #WolframTechConf

What is Cloud Connector for Excel?

A Plugin for Excel

Call Wolfram Enterprise Cloud from Excel

Access any Wolfram Language function within Excel

Example 1 - Classify

Classifier created from 40,000 recipes

"Data"

"Workbook"

What is Wolfram Enterprise Cloud?

A dedicated cloud for your business

APIs, Forms, Scheduled Tasks, Reports

Runs on a VM

Scalable

EPC Website

What are API Functions?

Written in Wolfram Language

Run in the cloud

Called with a web request

Easy to write

Quick to deploy

Example 2 - API Construction

Why Cloud Connector for Excel?

Extend Excel’s capabilities with Wolfram APIs

Supports typical Excel workflows

Server based computation

Example 3 - Real World Data

Cambridge Website

"Workbook"

API construction

data=URLFetch["http://jackdaw.cam.ac.uk/mailsearch/","Parameters"->{"surname"->"aa*","initials"->"","Search"->"Search","max"->"100",".cgifields"->"soundex",".cgifields"->"exactName"}]

StringCases[
	data,
		"<dl>"~~x___~~"</dl>":>x]

StringCases[
	data,
		"<dl>"~~x___~~"</dl>":>
		StringCases[
			x,{
				Shortest[
					"<dt>"~~name___~~"</dt>"
					~~___~~
					"<dd>"~~dept___~~",</dd>"
					~~___~~
					Shortest["\"mailto:"~~r___~~"\""]
					~~___~~
					"</dd>"
					]:>{name,dept,r}}]][[1]]//Grid

CloudDeploy[
	APIFunction[
		{"surname"->"String"->"",
		"initials"->"String"->"",
		"max"->"Integer"->100},
		Module[{data=URLFetch["http://jackdaw.cam.ac.uk/mailsearch/","Parameters"->{"surname"->#surname,"initials"->#initials,"Search"->"Search","max"->ToString[#max],".cgifields"->"soundex",".cgifields"->"exactName"}]},
		StringCases[
			data,
			"<dl>"~~x___~~"</dl>":>
			StringCases[
				x,{
					Shortest[
						"<dt>"~~name___~~"</dt>"
						~~___~~
						"<dd>"~~dept___~~",</dd>"
						~~___~~
						Shortest["\"mailto:"~~r___~~"\""]
						~~___~~
						"</dd>"
						]:>
						{name,dept,r}}]]
		]&,
		
		AllowedCloudExtraParameters->All
	],
	"WTC2017/Cambridge",
	Permissions->"Public"
]

Example 3 - Report Generation

"Workbook"

Generate Report

API which generates a full report from a template

Cloud API Explorer

Quick to use templating dialog

Stores APIs for further use

User Roles

The Excel User

The Developer

The System Administrator

Product Release

Preview Release

When can you get it?

Who can get it?

Website

Documentation

Website - Overview

Website - Why Connector?

Documentation

"Online Documentation"

Information for all user types

Summary

Simple Excel functions to call Wolfram APIs

Support for any Wolfram Language expression

Automated matrix expansion

Reference local files as parameters

Auto-updating output expressions

Convenient GUI for API parameter selection

Register Your Interest

https://wolfr.am/CloudConnector

Thank you for listening!