ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd

Community Cloud
1

Hi,

I try to deploy my app with the fantastic Streamlit Sharing, but the app is unable to open up the Excel file in there: ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

Locally, everything is fine; but when it comes to deploying the app, I get stuck on this.

Many thanks for your help.

2

If you’re opening an xlsx file using pd.read_excel(), you will need openpyxl. See pandas docs here.

3

openpyxl is already installed on my computer for a while tho …

4

Is it installed in production, and have you tried to set it as the pandas reader engine?

5

Yes I tried … but get again an error message.

6

It’s important to realize that having something installed locally is completely separate than having it installed on Streamlit sharing. We can’t read your local computer :slight_smile:

Best,
Randy

7

Thanks Randy for your answer.

I know this perfectly: I’ve updated my requirements.txt file accordingly, but this doesn’t solve my issue.

8

Can you post a link to your code?

9
10

I submitted a pull request that fixes this as far as I can tell:

image
image1862×1213 154 KB

Best,
Randy

11

Thanks so very much Randy !

This is really appreciated.

1 Like