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?
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?
These cookies are necessary for the website to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us understand how visitors move around the site and which pages are most frequently visited.
These cookies are used to record your choices and settings, maintain your preferences over time and recognize you when you return to our website. These cookies help us to personalize our content for you and remember your preferences.
These cookies may be deployed to our site by our advertising partners to build a profile of your interest and provide you with content that is relevant to you, including showing you relevant ads on other websites.