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

blob123 · March 6, 2021, 1:55pm

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.

asehmi · March 7, 2021, 11:19am

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

blob123 · March 8, 2021, 9:23am

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

asehmi · March 8, 2021, 9:40am

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

blob123 · March 8, 2021, 10:09am

Yes I tried … but get again an error message.

randyzwitch · March 8, 2021, 7:14pm

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

Best,
Randy

blob123 · March 8, 2021, 7:28pm

Thanks Randy for your answer.

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

randyzwitch · March 8, 2021, 7:32pm

Can you post a link to your code?

blob123 · March 8, 2021, 7:45pm

github.com

fredericgirod/french_real_estate/blob/main/leboncoin.py

# -*- coding: utf-8 -*-

"""
Created on Fri Mar  8 21:31:53 2019
@author: Frederic
"""

# pip install geopy 
# pip install Nominatim
# import requests
# import lxml.html as lh
import pandas as pd
import numpy as np
import datetime as dt
# import urllib.request
# from bs4 import BeautifulSoup
import os
# from  geopy.geocoders import Nominatim
from st_aggrid import GridOptionsBuilder, AgGrid, GridUpdateMode, DataReturnMode, JsCode
import plotly.graph_objects as go

This file has been truncated. show original

randyzwitch · March 8, 2021, 8:22pm

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

Best,
Randy

blob123 · March 8, 2021, 8:12pm

Thanks so very much Randy !

This is really appreciated.