nice we have a long way to cover so stay with me.
First is how to pull data from excel to a format that is ok to use in python y recomend for this to use pandas you need to install it by using pip install pandas
after that you can read the excel file whenever you want by using:
import pandas as pd
df = pd.read_excel (r’Path where the Excel file is stored\File name.xlsx’)
This is really usefull because now you have a dataframe which is ridiculously good at filtering data so you can easily filter by date,user,type of book and so.
Second what to use to display the data for this I recommend dash table which is a dash plugin you install by using pip install dash-table after this you can show nice tables pretty easy by following the examples in the official documentation https://dash.plot.ly/datatable i recommend you check out this first example directly pulld
third how to refresh the data for this wee need a callback that fires some changes anytime you change you dropdown. Here inside the callback you can load the excel sheet filter it and return the dash table to you html layout div where you wanna show the table as a result so basically inside here you can put the previous 2 steps a very resumed version of this would look like this.
def display_page(pathname, search):
df = load_dataframe_from_excel()
df = filter_dataframe_with_criteria()
table = create_table_with_dataframe()
Hope this helps and if you nned more you can ask anytime
here’s somoe documentation :