stand

An editable, filterable and sortable spreadsheet (via Ag Grid) webapp (via Streamlit) with REST API (via CherryPy) using Pandas DataFrames.

Setup the environment

conda create -n stand
conda activate stand

conda install cherrypy
conda install streamlit=1.9.2 altair=4
conda install streamlit-aggrid=0.3.4.post3
conda install openpyxl # excel writing
conda install pytables # hdf5 writing

Start the webapp

$ ./stand.py

Check the parameters with

$ ./stand.py -h

Interact in the browser

• edit: double click a cell

• filter: hover a column head and click the appearing menu icon

• sort: click a column head (cycles through ascending, descending, chronological)

• download: click the Downloads button and choose from the given options

Use the python client

from client import Client

c = Client()

c.add_row(a=1, b=2.3, c="three")
c.add_row(a=2, b=3.4, c="four", x=123)

c.clear()