Excel files in dropdown

Hi,

I just want to know the best way of implementing the uploaded excel files (using st.file_uploader) in a multiselect. I want to upload files like 2022, 2023, 2024 xlsxs and then select those excel files in the multiselect, so that the files load up according to the selection, and I can view the data. What is the best and efficient way to do that?

Hi @Sujith_Pisharody

You can use the read_excel method from Pandas to read excel files and display them in-app via st.dataframes.

https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html

Pandas can be used to concatenate multiple excel files via concat method from Pandas:

https://pandas.pydata.org/docs/reference/api/pandas.concat.html

Hope this helps!

Hi,

Thanks for the reply. But I would like to read excel files in st.multiselect and display the data accordingly. Can you help me with this?

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.