Skip to main content

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

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

jupyterexcel-0.0.1.tar.gz (3.7 kB view hashes)

Uploaded Source

Built Distribution

jupyterexcel-0.0.1-py3-none-any.whl (16.7 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page