A Jupyter extensions to make notebooks web api for Excel to call. Jupyter Excel
This is a package to make Jupyter.ipynb file a web api with json result. 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 thorugh 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
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://126.96.36.199:8888/Excel/TestingJupyter.ipynb?token=ABCD&functionname=sum&1=11&2=8&3=6 http://188.8.131.52:8888/notebooks/TestingJupyter.ipynb '''
The following screenshot shows how excel works.
Future Development Plan
- Make jupyterexcel can take Post call for large data from Excel and handle Array formula
- Make Excel client side more easier to use, such as generate Excel formula proxy
- Possible add ribbon in Excel and call into Jupyter function with button click
- 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.7-py3-none-any.whl (6.4 kB)||File type Wheel||Python version py3||Upload date||Hashes View hashes|
|Filename, size jupyterexcel-0.0.7.tar.gz (4.9 kB)||File type Source||Python version None||Upload date||Hashes View hashes|
Hashes for jupyterexcel-0.0.7-py3-none-any.whl