JupyterLab Extensions for Spreadsheet

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Tools and JupyterLab Extensions for SpreadSheet¶

Google Spreadsheet¶

One (potentially good) way is to manipulate Google Spreadsheet using Python. Please refer to Use Python With Google Spreadsheet for more details.

jupyterlab-tabular-data-editor¶

jupyterlab-tabular-data-editor allows you to manipulate tabular data responsively and effectively within JupyterLab.

jupyterlab-spreadsheet¶

The extension jupyterlab-spreadsheet provides a way to view Excel files. This makes it possible to work with simple Excel file in JupyterLab with the help of the Python library XlsxWriter. Basically, you can create rich-format Excel files using the Python library XlsxWriter and view it using jupyterlab-spreadsheet.

itables¶

ipysheet¶

ipyaggrid¶

qgrid¶

Underlying JavaScript Libraries¶

DataTables¶

ag-grid¶

References¶

itables Notebook Examples

https://towardsdatascience.com/interactive-spreadsheets-in-jupyter-32ab6ec0f4ff