JSPM

  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 5
  • Score
    100M100P100Q41619F
  • License BSD-3-Clause

JupyterLab spreadsheet (csv/tsv) editor

Package Exports

  • spreadsheet-editor

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (spreadsheet-editor) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

JupyterLab Spreadsheet Editor

JupyterLab spreadsheet editor enables interactive editing of comma/tab separated value spreadsheets. It support formulas, sorting, column/row rearrangements and more!

Showcase

Fully featured integration

  • row/column operations, column width adjustment
  • search and replace

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).

Requirements

  • JupyterLab >= 2.0

Install

jupyter labextension install spreadsheet-editor

Contributing

Install

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
# Move to spreadsheet-editor directory

# Install dependencies
jlpm
# Build Typescript source
jlpm build
# Link your development version of the extension with JupyterLab
jupyter labextension link .
# Rebuild Typescript source after making changes
jlpm build
# Rebuild JupyterLab after making any changes
jupyter lab build

You can watch the source directory and run JupyterLab in watch mode to watch for changes in the extension's source and automatically rebuild the extension and application.

# Watch the source directory in another terminal tab
jlpm watch
# Run jupyterlab in watch mode in one terminal tab
jupyter lab --watch

Uninstall

jupyter labextension uninstall spreadsheet-editor

Spreadsheet viewers:

In-notebook spreadsheet widgets:

  • ipysheet - programmable sheet creation, exploration and modification
  • qgrid - interactive DataFrame exploration and modification