A Jupyter extensions to make notebooks web api for Excel to call using UDF forumla or Ribbon Callback. Jupyter Excel, Python Excel
This is a package to make Jupyter.ipynb file a web api with json result. You can call Jupyter from Excel Formula or Ribbon CallBack Functions SourceCode in JupyterExcel
This Jupyter Excel web api can be connected with Excel addin which call this web api. Excel formula will generate a web api url and through winhttp to get json result.
pip install jupyterexcel
jupyter serverextension enable --py jupyterexcel
Please config jupyter server like the following:
c.NotebookApp.token = 'ABCD' #it is good to use token mode for web api call to pass through c.NotebookApp.allow_remote_access = True #if you like to set to access from other computer
The following screenshot shows the sample notebook file with a function sum. You can download TestingJupyter.ipynb or create your own. The following is an instance I hosted in google cloud platform, you can open and add a function of yours. ''' http://184.108.40.206:8888/Excel/TestingJupyter.ipynb?token=ABCD&functionname=sum&1=11&2=8&3=6 http://220.127.116.11:8888/notebooks/TestingJupyter.ipynb '''
The following screenshot shows how excel Formula works.
The following screenshot Shows how Ribbon Call Back function works
Future Development Plan
- Make Excel client side more easier to use, such as generate Excel formula proxy
- Able to support R, Julia ....
read some code from appmode
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size jupyterexcel-0.0.8-py3-none-any.whl (6.7 kB)||File type Wheel||Python version py3||Upload date||Hashes View hashes|
|Filename, size jupyterexcel-0.0.8.tar.gz (5.1 kB)||File type Source||Python version None||Upload date||Hashes View hashes|
Hashes for jupyterexcel-0.0.8-py3-none-any.whl