PYTHON NOTEBOOKS. EXCEL WORKBOOKS.

Your notebook.
Now an Excel
function.

Write your logic in Python. Use it in an Excel formula. JupyterForExcel connects the notebook you build with the spreadsheet you work in.

Set up the add-in See it in action

Custom formulas   /   Notebook actions   /   JupyterHub

notebook.ipynbPYTHON
from jupyterexcel import jupyter_function

@jupyter_function
def add_tax(amount, rate):
    return amount * (1 + rate)
One decorator. Your Python function.
AVAILABLE IN EXCEL
Budget.xlsx EXAMPLE
ƒx=Jupyter.add_tax(B2, C2)
ABCD
1ItemAmountTax rateTotal
2Supplies1008%108.00
3 
Sheet1

Illustrative formula example. Try the connected add-in in Excel.

Keep Python in your notebook.Bring the result to your worksheet.

THE ADD-IN IN ACTION

From a cell to a whole workflow.

Two ways to use your notebook in Excel.

01 / FORMULAS

A familiar formula.
Your Python behind it.

Expose a notebook function with @jupyter_function, then call it from a worksheet. Pass numbers or cell ranges and use the returned result in your workbook.

=Jupyter.Sum(1, 2, 3)
Try your first formula
A Python Sum function in JupyterLab alongside the corresponding formula in Excel.
A notebook function, called directly from an Excel cell. Select the image to enlarge.
02 / NOTEBOOK ACTIONS

Run a notebook action.
Fill your worksheet.

Use the Actions pane for tasks that need inputs and tabular output. The Query Price Data example generates simulated price data and writes it to the selected starting cell.

Explore the ribbon example
The Query Price Data action in Excel with its Python notebook and generated price table.
Python inputs and results, available from the Excel ribbon.

GET STARTED

Connect your first workbook.

Full setup guide
  1. 1

    Install the add-in

    Download the demo manifest and follow the setup guide to load it in Excel for Windows.

    Download manifest.xml ↗
  2. 2

    Connect to Jupyter

    Sign in to JupyterHub, then enter your access token using the Token command in Excel.

    Open JupyterHub ↗
  3. 3

    Try a formula or action

    Call a notebook function from a cell, or open Actions to run the ribbon example.

    Follow the demo ↗

MAKE IT YOUR OWN

Your notebooks.
Your Jupyter server.

Install the Python package and connect the add-in to your own deployment. Choose a formula namespace and keep your calculation logic in notebooks.

Source code & server setup ↗
INSTALL THE PYTHON PACKAGE
pip install jupyterexcel

For the Office.js features shown here, use release 0.1.0 or later when available. Check the repository for the current release.