Excel files in dropdown

Random
1

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?

2

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!

3

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?

4

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