FileNotFoundError: This app has encountered an error

[DhananjayPorwal]

I’m trying to deploy this app at streamlit. It works fine on localhost but encounters errors at the time of deployment. Usually when I upload file, it throws error.

FileNotFoundError: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs (if you're on Streamlit Cloud, click on 'Manage app' in the lower right of your app).

Traceback:

File "/home/appuser/venv/lib/python3.9/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 556, in _run_script
    exec(code, module.__dict__)
File "/app/shop-analysis/app.py", line 42, in <module>
    df = get_data_from_excel()
File "/app/shop-analysis/app.py", line 24, in get_data_from_excel
    df = pd.read_excel(
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 311, in wrapper
    return func(*args, **kwargs)
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 457, in read_excel
    io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 1419, in __init__
    self._reader = self._engines[engine](self._io, storage_options=storage_options)
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/io/excel/_openpyxl.py", line 525, in __init__
    super().__init__(filepath_or_buffer, storage_options=storage_options)
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 508, in __init__
    self.handles = get_handle(
File "/home/appuser/venv/lib/python3.9/site-packages/pandas/io/common.py", line 795, in get_handle
    handle = open(handle, ioargs.mode)

Thanks in advance

[mathcatsand]

The file uploader widget just stores the file in memory, so it won’t help to just give pandas the name of that file. You will need to pass the BytesIO data to it:

Try this:

uploaded_file = st.file_uploader(
    "Choose your database", accept_multiple_files=False)
if uploaded_file is not None:
    file_name = uploaded_file
else:
    file_name = "DatabaseSample.xlsx"

This way, you either pass the name of the file you have pre-saved or you pass the BytesIO data of something new from the user.

[DhananjayPorwal]

Thanks buddy, it works
Can you tell me how you got the idea to fix this error?

[mathcatsand]

Just from the documentation. Every single function in every single library has specific requirements about data types it accepts and returns. Python lets us be a little hand-wavy about it, but for all coding you always want to have a firm grasp of what each object’s data type is.

[DhananjayPorwal]

Thanks for the help

[Reindrow_Owen]

Where can i try this code?

[mathcatsand]

I don’t have that particular snippet hosted anywhere, so you can copy it into your own app.py file to work with. Feel free to post a question if you are having some difficulty using it.