jupyterlab-spreadsheet-editor
Advanced tools
JupyterLab spreadsheet editor enables interactive editing of comma/tab separated value spreadsheets. It support formulas, sorting, column/row rearrangements and more!
Note: you might be interested to checkout tabular-data-editor as well
Fully featured integration
Formula support basic formula calculation (rendering) - as implemented by jExcel.
Column freezing for exploration of wide datasets with many covariates
Launcher items: create CSV/TSV files easily from the launcher or the palette.
Lightweight and reliable dependencies: the spreadsheet interface is built with the jexcel, while Papa Parse provides very fast, RFC 4180 compatible CSV parsing (both have no third-party dependencies).
pip install jupyterlab-spreadsheet-editor
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 jupyterlab-spreadsheet-editor 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
pip uninstall jupyterlab-spreadsheet-editor
Spreadsheet editors:
Spreadsheet viewers:
In-notebook spreadsheet widgets:
FAQs
JupyterLab spreadsheet (csv/tsv) editor
We found that jupyterlab-spreadsheet-editor demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.