Unable to read excel file - getting ModuleNotFoundError

Question

I am trying to read an excel file in Python. When I try and import the correct module, it doesn't work.

My code is:

from xlrd import open_workbook
wb = openpyxl.load_workbook('example.xlsx')
type(wb)

and I get this error:

from xlrd import open_workbook
ModuleNotFoundError: No module named 'xlrd'

Can anyone help me please?

Looks like `xlrd` that you're trying to import `open_workbook` from does not exist/is not installed. — sudo_coffee, Feb 22 '17 at 19:10
Apart from the `ModuleNotFoundError`, you appear to be (trying to) import `xlrd` but then on the next line, using a different module altogether, `openpyxl`. — SiHa, Feb 22 '17 at 19:40

sudo_coffee · Answer 1 · 2017-02-22T19:24:48.687

0

It looks like xlrd is not found/does not exist for the instance of Python you're using.

Assuming you're using Python3, you'll want to use pip3 to get modules that aren't already available. Install Python 3's pip with

sudo aptget install python3-pip Then install packages with pip3 install xlrd

If you're using Python2, follow the directions from Adam and do pip install xlrd

edited Feb 22 '17 at 19:24

answered Feb 22 '17 at 19:15

sudo_coffee

740
1
9
26

where do i type that? – Luke Timbrell Feb 22 '17 at 19:21
Are you using Windows, MacOS, or Linux? Mac/Linux open a terminal session and type it. I'm not familiar with Windows, but this could be of help: http://stackoverflow.com/questions/4750806/how-do-i-install-pip-on-windows – sudo_coffee Feb 22 '17 at 19:23
yeh i am using windows – Luke Timbrell Feb 22 '17 at 19:24
Follow the instructions from the link I provided you, then enter `pip install xlrd`. – sudo_coffee Feb 22 '17 at 19:26

score 0 · Answer 2 · answered Feb 22 '17 at 19:16

0

Try typing into the cmd prompt or terminal:

python -c "import xlrd; print xlrd.__VERSION__"

If that fails try using pip to install it.

pip install xlrd

you can try the first step again to check that it's worked

answered Feb 22 '17 at 19:16

Adam Slack

444
6
11

where do i type this? – Luke Timbrell Feb 22 '17 at 19:21
if you're on windows, open up a command prompt. and try typing it in there. you can get to it through the start menu, or by pressing `windows + R` and then typing `cmd` into the window that pops up – Adam Slack Feb 22 '17 at 19:25
if you can't use pip, it might not be installed. go to their site https://pip.pypa.io/en/stable/installing/ and it should talk you through getting installed. – Adam Slack Feb 22 '17 at 19:30
which part? `windows + R`? – Adam Slack Feb 22 '17 at 19:32
yeh it does not do anything – Luke Timbrell Feb 22 '17 at 19:34
if you have the cmd prompt up, does typing `python` and then hitting enter do anything? it should start a command line python session – Adam Slack Feb 22 '17 at 19:35
it say " 'python' is not recognised as an internal or external command, operable program or batch file – Luke Timbrell Feb 22 '17 at 19:37
this might sound stupid, but do you have python installed? – Adam Slack Feb 22 '17 at 19:38
yes i do, I will try uninstalling it and installing it again – Luke Timbrell Feb 22 '17 at 19:39
try having a look at a pre-packaged distribution called `anaconda`. it comes with a tonne of useful packages and i believe xlrd is included in that. https://www.continuum.io/downloads – Adam Slack Feb 22 '17 at 19:40
well it installs python, but with a lot of the additional libraries that people commonly use. my thinking was that if you're planning to re-install it, you might as well go straight in with that – Adam Slack Feb 22 '17 at 19:43
No worries, had any luck? – Adam Slack Feb 22 '17 at 19:50
its just downloading it now – Luke Timbrell Feb 22 '17 at 19:51

Unable to read excel file - getting ModuleNotFoundError

2 Answers2