Getting AggGrid's state

[adamlansky]

Hey @PablocFonseca, thank you for such an amazing job on integrating AggGrid in Streamlit, I highly appreciate the efforts and happy to contribute if there are any known issues that need help from python side of things.

One task I am having hard time to wrap my head around is getting AggGrid state after a user interacts with it.

I.e., I have a multi-select to keep grouping consistent between page reloads or new data push.

# let user pick cols from dataframe she want to group by
if st.sidebar.checkbox("Enable default grouping"):
    default_group_col = st.sidebar.selectbox("Default group by: ", cols, 1)

# if any of columns are selected, apply it to aggrid and persist on page reload,
# as default_group_col state is persisted under the hood by streamlit
try:
    gb.configure_column(default_group_col, rowGroup=True)
except:
    pass

Now say a user groups by an additional column using AggGrid groupby feature, collapses some of the resulting groups and keeps the others expanded. I would assume AggGrid itself stores this state somewhere in client side JS. Is there a potential way to get stat state back to python in order to save it somewhere in a dict and persist between page reloads when AggGrid component is being redrawn or populated with new data?

Thanks!

[ragrawal]

I have a similar question. Is there a way to get the modified data back in python

[PablocFonseca]

check the example folder (e.g. two_grids.py)
to get modified data, you would use something like:

grid_return = AgGrid(df, key='grid1', editable=True)
df = grid_return['data']
st.write(df)

[PablocFonseca]

The feature to save grid's current state is not implemented yet.
I just saw this post: https://blog.ag-grid.com/persisting-ag-grid-state-with-react-redux/#managing-state-in-ag-grid

So, it can be done. Unfortunately, I'm lacking the time to dig into this..

[gandhis1]

This issue was closed as completed, is it completed? I think leaving this one open would make sense until it is actually implemented. I would very much find this feature useful.

[estaar]

Hi. Was this feature implemented. Would you suggest what to edit in J's code to make this work?