streamlit upload a folder read all the excel workbook create a selection bar for the workbook name

To upload a folder and read all the Excel workbooks in Streamlit, you can use the streamlit.file_uploader function and the pandas library. Here's an example code snippet:

import streamlit as st
import pandas as pd
import os

# Upload folder
uploaded_folder = st.file_uploader("Upload folder", type="zip")

if uploaded_folder:
    # Extract files from folder
    folder_name = os.path.splitext(uploaded_folder.name)[0]
    os.makedirs(folder_name, exist_ok=True)
    with open(uploaded_folder.name, "wb") as f:
        f.write(uploaded_folder.getvalue())
    import zipfile
    with zipfile.ZipFile(uploaded_folder.name, "r") as zip_ref:
        zip_ref.extractall(folder_name)

    # Read Excel files
    excel_files = []
    for file in os.listdir(folder_name):
        if file.endswith(".xlsx"):
            excel_files.append(file)
    if not excel_files:
        st.write("No Excel files found in folder.")
    else:
        # Create selection bar for workbook name
        selected_file = st.selectbox("Select workbook:", excel_files)

        # Read selected workbook
        df = pd.read_excel(os.path.join(folder_name, selected_file))
        st.write(df)

This code will allow the user to upload a zip folder containing Excel workbooks, extract the files to a new directory, and read all the Excel files. It then creates a selection bar for the user to choose which workbook to display. The selected workbook is then read using pandas and displayed in the Streamlit app.

Note that this code assumes that all Excel workbooks are in the .xlsx format. If you have workbooks in other formats, you will need to modify the code to handle those files appropriately