# ipysheet
# WARNING
Due to [Handsontable licensing changes](https://handsontable.com/blog/articles/2019/3/handsontable-drops-open-source-for-a-non-commercial-license) 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](https://github.com/bloomberg/ipydatagrid).
Spreadsheet in the Jupyter notebook:
* Try it out using binder: [](https://mybinder.org/v2/gh/QuantStack/ipysheet/stable?filepath=docs%2Fsource%2Findex.ipynb)
* Or check out the documentation at [https://ipysheet.readthedocs.io/](https://ipysheet.readthedocs.io/en/stable/)
**Create a table and drive a value using ipywidgets:**
**Perform a calculation on slider change:**
**Change cell style depending on the value using renderers:**
**Populate table using cell ranges:**
# 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](https://yarnpkg.com/) that is installed with JupyterLab. You may use
`yarn` or `npm` in lieu of `jlpm` below.
```bash
# 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.
```bash
# 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:
```bash
jupyter lab build --minimize=False
```
### Development uninstall
```bash
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.
Raw data
{
"_id": null,
"home_page": "https://github.com/QuantStack/ipysheet",
"name": "ipysheet",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": "",
"keywords": "Jupyter,JupyterLab,JupyterLab3",
"author": "Maarten A. Breddels",
"author_email": "michael.barry@gmo.com",
"download_url": "https://files.pythonhosted.org/packages/80/9d/9466945e6af30b68dfdbbb36f1ebc3b4353bf7d117bcf678deaaad88d1c7/ipysheet-0.7.0.tar.gz",
"platform": "Linux",
"description": "# ipysheet\n\n# WARNING\n\nDue to [Handsontable licensing changes](https://handsontable.com/blog/articles/2019/3/handsontable-drops-open-source-for-a-non-commercial-license) ipysheet is stuck witch the outdated Handsontable version 6.2.2 (open-source).\nWe recommend not using ipysheet anymore. We suggest an alternative like [ipydatagrid](https://github.com/bloomberg/ipydatagrid).\n\nSpreadsheet in the Jupyter notebook:\n\n * Try it out using binder: [](https://mybinder.org/v2/gh/QuantStack/ipysheet/stable?filepath=docs%2Fsource%2Findex.ipynb)\n * Or check out the documentation at [https://ipysheet.readthedocs.io/](https://ipysheet.readthedocs.io/en/stable/)\n\n**Create a table and drive a value using ipywidgets:**\n\n\n\n**Perform a calculation on slider change:**\n\n\n\n**Change cell style depending on the value using renderers:**\n\n\n\n**Populate table using cell ranges:**\n\n\n\n# Installation\n\nWith conda:\n\n```\n$ conda install -c conda-forge ipysheet\n```\n\nWith pip:\n\n```\n$ pip install ipysheet\n```\n\n### Development install\n\nNote: You will need NodeJS to build the extension package.\n\nThe `jlpm` command is JupyterLab's pinned version of\n[yarn](https://yarnpkg.com/) that is installed with JupyterLab. You may use\n`yarn` or `npm` in lieu of `jlpm` below.\n\n```bash\n# Clone the repo to your local environment\n# Change directory to the ipysheet directory\n# Install package in development mode\npip install -e .\n# Link your development version of the extension with JupyterLab\njupyter labextension develop . --overwrite\n# Rebuild extension Typescript source after making changes\njlpm run build\n```\n\nYou 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.\n\n```bash\n# Watch the source directory in one terminal, automatically rebuilding when needed\njlpm run watch\n# Run JupyterLab in another terminal\njupyter lab\n```\n\nWith 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).\n\nBy 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:\n\n```bash\njupyter lab build --minimize=False\n```\n\n### Development uninstall\n\n```bash\npip uninstall ipysheet\n```\n\nIn development mode, you will also need to remove the symlink created by `jupyter labextension develop`\ncommand. To find its location, you can run `jupyter labextension list` to figure out where the `labextensions`\nfolder is located. Then you can remove the symlink named `ipysheet` within that folder.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Spreadsheet in the Jupyter notebook.",
"version": "0.7.0",
"project_urls": {
"Homepage": "https://github.com/QuantStack/ipysheet"
},
"split_keywords": [
"jupyter",
"jupyterlab",
"jupyterlab3"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "ec44ab16eb682f354b85dfc7d53746fc5772ca2244d7b6d659126bf0b934430d",
"md5": "934e7e5a8d0bf5499cee2add3788c401",
"sha256": "0a5179815444977fbc2317bab6133a3af179c4155996dd3f723b4d10f2d5a970"
},
"downloads": -1,
"filename": "ipysheet-0.7.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "934e7e5a8d0bf5499cee2add3788c401",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.6",
"size": 3831607,
"upload_time": "2022-11-28T09:23:17",
"upload_time_iso_8601": "2022-11-28T09:23:17.849458Z",
"url": "https://files.pythonhosted.org/packages/ec/44/ab16eb682f354b85dfc7d53746fc5772ca2244d7b6d659126bf0b934430d/ipysheet-0.7.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "809d9466945e6af30b68dfdbbb36f1ebc3b4353bf7d117bcf678deaaad88d1c7",
"md5": "62afa07670a8971f125f90c645e6c4ca",
"sha256": "34587a02d3bc304724126f9a6dbdf8237a04a6a7aec98a8ffbda16f93fe4ec27"
},
"downloads": -1,
"filename": "ipysheet-0.7.0.tar.gz",
"has_sig": false,
"md5_digest": "62afa07670a8971f125f90c645e6c4ca",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 2016930,
"upload_time": "2022-11-28T09:23:23",
"upload_time_iso_8601": "2022-11-28T09:23:23.726321Z",
"url": "https://files.pythonhosted.org/packages/80/9d/9466945e6af30b68dfdbbb36f1ebc3b4353bf7d117bcf678deaaad88d1c7/ipysheet-0.7.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2022-11-28 09:23:23",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "QuantStack",
"github_project": "ipysheet",
"travis_ci": true,
"coveralls": false,
"github_actions": false,
"requirements": [
{
"name": "notebook",
"specs": [
[
">=",
"5.3"
]
]
},
{
"name": "ipysheet",
"specs": []
},
{
"name": "flexx",
"specs": []
}
],
"lcname": "ipysheet"
}
JSON
