Skip to main content

A Jupyter Excel 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 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.

Installation

pip install jupyterexcel

then run

jupyter serverextension enable --py --sys-prefix jupyterexcel

Server setting

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

Example

The following screenshot shows the sample notebook file with a function sum. You can download TestingJupyter.ipynb or create your own. 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

Future Development Plan

  1. Make jupyterexcel can take Post call for large data from Excel
  2. Make Excel client side more easier to use, such as generate Excel formula proxy
  3. Possible add ribbon in Excel and call into Jupyter function with button click

Reference

read some code 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.

Files for jupyterexcel, version 0.0.2
Filename, size File type Python version Upload date Hashes
Filename, size jupyterexcel-0.0.2-py3-none-any.whl (5.2 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size jupyterexcel-0.0.2.tar.gz (3.9 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page