How to install openpyxl in streamlit cloud

Community Cloud
1

I have put openpyxl in my requirememts.txt file and still getting error ImportError: Missing optional dependency ‘openpyxl’. when deployed my app.

2

Hi @nitinbhardwaj28

Yes that is correct on adding openpyxl to requirements.txt file. Was this added after the app was deployed. It often helps to also reboot the app in order to ensure that the newly added library is installed after the server reboots.

Hope this helps!

3

Thanks for the reply . after rebooting the server still not able to resolve the issue .

image
image1913×861 155 KB

4

also added my my requiremet.txt file content.

streamlit
pandas
numpy
openpyxl==3.0.14

5

Hi @nitinbhardwaj28

Could you recheck the spelling of the file, it’s currently misspelled (missing an n and an s):

It should be requirements.txt

6

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