FileNotFoundError I cannot upload excel file from Github repo after streamlit app deployed

Using Streamlit
, ,
1

I cannot upload excel file from Github repo after streamlit app deployed on Community Cloud.
Could you help me upload the excel file to deployed app?
Please note that the excel data is already in the Github repo, and it worked before deployment.

Here is the link of the deployed app https://online-jwidos9dtrrofghtulbwum.streamlit.app/
Git Hub repository is here: GitHub - j-ago/online
Here is the full text of the error message:

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/adminuser/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/exec_code.py", line 75, in exec_func_with_error_handling
    # so we track this to potentially skip session state cleanup later.
                 ^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 574, in code_to_execFile "/mount/src/online/online.py", line 7, in <module>
    df = pd.read_excel('20240806_アンバランス度質問シート_rawdata.xlsx')
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/pandas/io/excel/_base.py", line 495, in read_excel
    io = ExcelFile(
         ^^^^^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/pandas/io/excel/_base.py", line 1550, in __init__
    ext = inspect_excel_format(
          ^^^^^^^^^^^^^^^^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/pandas/io/excel/_base.py", line 1402, in inspect_excel_format
    with get_handle(
         ^^^^^^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/pandas/io/common.py", line 882, in get_handle
    handle = open(handle, ioargs.mode)
             ^^^^^^^^^^^^^^^^^^^^^^^^^

Here is the requirements:
streamlit==1.37.1
matplotlib==3.8.0
openpyxl==3.1.3

2

Hi @Jun1, welcome to the community! :wave:

It looks like the linux container in which the cloud app is deployed isn’t able to handle/encode the non English characters in the the filename. If you rename the Excel file on GitHub to something like this, it should work: 20240806_rawdata.xlsx

Or you could normalize the filename to ensure it’s in a consistent Unicode format:

import pandas as pd
import unicodedata
import streamlit as st

# Original filename
filename = '20240806_アンバランス度質問シート_rawdata.xlsx'

# Normalize the filename
normalized_filename = unicodedata.normalize('NFC', filename)

# Read the Excel file
df = pd.read_excel(normalized_filename)

image
image2028×1702 278 KB

4

@snehankekre Thank you, it worked!

1 Like
5

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