Connecting Excel with the Wolfram Enterprise Private (EPC) Cloud

Anthony Zupnik, Wolfram Research

Join the Conversation #WolframTechConf

What is the Excel Cloud Link?

Communicate with EPC via Excel

Use Instant APIs  as UDFs (User Defined Functions)

Translate Wolfram expression to native Excel

Emphisis on end user ease of use

Motivation for an Excel to EPC link

Hyperlink["https://www.wolfram.com/enterprise-private-cloud/",BaseStyle->"Subchapter"]

Everyone knows Excel

Wolfram Language vastly surparses Excel functionality

Utilize EPC’s powerful features

Forms

APIs

Cloud Notebooks

Scheduled tasks

Reporting

Minimize programmatical knowledge

Decreased Setup Costs (Minimal install for end user)

Wolfram Enterprise Private Cloud

Key Points relating to APIs

Instant API deployment

Can be called by GET/POST request

Written in pure Wolfram Language

A centralized database for code/data

Can schedule reporting mechanisms

API Function

Fast API Construction

Interpreter Integration

CloudDeploy[
	APIFunction[
		{"x"->RepeatingElement["City",{1,100}]},
		ExportForm[Grid[(Prepend[List@@#["Population"],#["Name"]])&/@#x],"HTMLFragment"]&
	],
	Permissions->"Public"
]

Multi-format Support (Import/Export)

CloudDeploy[
	APIFunction[
		{
			"city"->"City",
			"distance"->DelimitedSequence[Restricted["Quantity", QuantityVariable["Distance"]],","]
		},
		GeoGraphics[Table[GeoCircle[#city,r],{r,#distance}]]&,
		"PNG"
	],
	Permissions->"Public"
]

Workflow 1 - Model Optimization

Workflow 2 - Integrate with Real World Data

Workflow 3 - Manage Dynamic Libraries

Demo  - Excel Data into an Interactive Report

Get Data

API which gives 20 Day Volatility

API which gives Stock Price as a single value or an array

Visualize Data

API which plots our finanicial data

Generate Report

API which generates a full report from a template

Example 1 - Simple Response

Example 2 - Arrays

Example 3 - Graphics

Example 4 - Graphics Array

Example 5 - Dynamic Array/Column/Row

Example 6 - VBA Integration

Example 7- Uploading Files

Example 8 -  Uploading Data

Summary of Features

Matrix expansion

Display any expression

Automatic formatting

Dynamic data expansion

Integration with VBA

File parameter

Data/file uploading

Conclusion

Once deployed, your API is ready to use by your users

Mistakes in production code can be rectified with a simple CloudDeploy

Speed with Private Cloud is quite favorable

End user requires no knowledge of Wolfram Language

Thank you for listening!