Ben Chuanlong Du's Blog

It is never too late to learn.

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

Comments