Skip to main content

Spreadsheet in the Jupyter notebook.

Project description

ipysheet

WARNING

Due to Handsontable licensing changes ipysheet is stuck witch the outdated Handsontable version 6.2.2 (open-source). We recommend not using ipysheet anymore. We suggest an alternative like ipydatagrid.

Spreadsheet in the Jupyter notebook:

Create a table and drive a value using ipywidgets:

Slider Screencast

Perform a calculation on slider change:

Slider Calculation Screencast

Change cell style depending on the value using renderers:

Conditional formatting

Populate table using cell ranges:

Cell Ranges Screencast

Installation

With conda:

$ conda install -c conda-forge ipysheet

With pip:

$ pip install ipysheet

Development install

Note: You will need NodeJS to build the extension package.

The jlpm command is JupyterLab's pinned version of yarn that is installed with JupyterLab. You may use yarn or npm in lieu of jlpm below.

# Clone the repo to your local environment
# Change directory to the ipysheet directory
# Install package in development mode
pip install -e .
# Link your development version of the extension with JupyterLab
jupyter labextension develop . --overwrite
# Rebuild extension Typescript source after making changes
jlpm run build

You can watch the source directory and run JupyterLab at the same time in different terminals to watch for changes in the extension's source and automatically rebuild the extension.

# Watch the source directory in one terminal, automatically rebuilding when needed
jlpm run watch
# Run JupyterLab in another terminal
jupyter lab

With the watch command running, every saved change will immediately be built locally and available in your running JupyterLab. Refresh JupyterLab to load the change in your browser (you may need to wait several seconds for the extension to be rebuilt).

By default, the jlpm run build command generates the source maps for this extension to make it easier to debug using the browser dev tools. To also generate source maps for the JupyterLab core extensions, you can run the following command:

jupyter lab build --minimize=False

Development uninstall

pip uninstall ipysheet

In development mode, you will also need to remove the symlink created by jupyter labextension develop command. To find its location, you can run jupyter labextension list to figure out where the labextensions folder is located. Then you can remove the symlink named ipysheet within that folder.

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

ipysheet-0.6.0.tar.gz (2.0 MB view details)

Uploaded Source

Built Distribution

ipysheet-0.6.0-py2.py3-none-any.whl (3.8 MB view details)

Uploaded Python 2 Python 3

File details

Details for the file ipysheet-0.6.0.tar.gz.

File metadata

  • Download URL: ipysheet-0.6.0.tar.gz
  • Upload date:
  • Size: 2.0 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.10.6

File hashes

Hashes for ipysheet-0.6.0.tar.gz
Algorithm Hash digest
SHA256 6c7123f5f25beb0d4a8f04222c0ad10b4bf6e48e7c2c86fbc13c4d2dc4b5b5dc
MD5 74989514c2c55432e1c0ff62989a7d32
BLAKE2b-256 e0e4f7e6206052ed8b0d192b26d9b07285e9bd8c1030ad363e77871ca2bc3088

See more details on using hashes here.

Provenance

File details

Details for the file ipysheet-0.6.0-py2.py3-none-any.whl.

File metadata

  • Download URL: ipysheet-0.6.0-py2.py3-none-any.whl
  • Upload date:
  • Size: 3.8 MB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.10.6

File hashes

Hashes for ipysheet-0.6.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 1e26bc92e751460245cc86a9bf07c5f172c3edd77b4f87802e13e3981b5bc257
MD5 f31bb22a04693dfacd009845c566fa12
BLAKE2b-256 a91469323294252e1d6944641525fa8ecaf49e6368bce151f074bf26d5c525d9

See more details on using hashes here.

Provenance

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