forked from PablocFonseca/streamlit-aggrid-examples
-
Notifications
You must be signed in to change notification settings - Fork 0
/
user_settings.py
64 lines (53 loc) · 1.63 KB
/
user_settings.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
from distutils.ccompiler import gen_preprocess_options
import streamlit as st
from st_aggrid import AgGrid, GridOptionsBuilder, GridUpdateMode
import pandas as pd
data = pd.DataFrame(
[
["JW", "Project Leader"],
["SSS", "Administrador"],
["AJH", "Asset Manager"],
["BM", "Project Leader"],
["RHE", "Finance Officer"],
["AC", "Cleaner"],
["AMM", "Manager"],
["PS", "Manager"],
["KYL", "Manager"],
],
columns=["User", "Position"],
)
columns_state = None
gb1 = GridOptionsBuilder.from_dataframe(data)
gb1.configure_selection(selection_mode="multiple", use_checkbox=True)
gb1.configure_side_bar()
go1 = gb1.build()
if st.button("Load Column State"):
columns_state
gridState = {
"sideBar": {
"visible": True,
"position": "right",
"openToolPanel": "filters",
"toolPanels": {
"filters": {"expandedGroupIds": [], "expandedColIds": ["Position"]},
"columns": {"expandedGroupIds": []},
},
},
"columnSizing": {
"columnSizingModel": [
{"colId": "User", "width": 200},
{"colId": "Position", "width": 200},
]
},
"columnOrder": {"orderedColIds": ["User", "Position"]},
"rowSelection": ["5"],
"focusedCell": {"colId": "User", "rowIndex": 5, "rowPinned": None},
}
go1["initialState"] = gridState
grid1 = AgGrid(
data,
go1,
update_mode=GridUpdateMode.MODEL_CHANGED | GridUpdateMode.COLUMN_RESIZED,
enable_enterprise_modules=True,
)
st.write(grid1.grid_response)