jupyterexcel 0.0.1

A Jupyter extensions to make notebooks web api for Excel to call

jupyterexcel Package

This is a package to make Jupyter .ipynb file a web api with json result. SourceCode in JupyterExcel

This web api can be connected with Excel addin which call this web api. Excel formula will generate a web api url and thorugh winhttp to get json result.

server setting

Please config jupyter server like the following:

c.NotebookApp.nbserver_extensions = {'jupyterexcel': True} c.NotebookApp.token = 'ABCD' #it is good to use token mode for web api call to pass through

Example

The following screenshot shows the sample notebook file with a function sum http://localhost:8888/Excel/TestingJupyter.ipynb?token=ABCD&functionname=sum&1=11&2=8&3=6 NotebookExample

The following screenshot shows how excel works Jupyter Excel

Reference

Load lots from appmode