Sep-24-2019, 03:31 PM
I want to extract data from Excel sheet and I got the following error like
ImportError: No module named xlrd
Then I looked at where Python is reading from by entering the following commands
import sys
print sys.path
['', '/opt/miniconda/current/lib/python27.zip', '/opt/miniconda/current/lib/python2.7', '/opt/miniconda/current/lib/python2.7/plat-linux2', '/opt/miniconda/current/lib/python2.7/lib-tk', '/opt/miniconda/current/lib/python2.7/lib-old', '/opt/miniconda/current/lib/python2.7/lib-dynload', '/opt/miniconda/current/lib/python2.7/site-packages', '/opt/miniconda/current/lib/python2.7/site-packages/setuptools-15.0-py2.7.egg']
but, xlrd package is in the location "/opt//projects/software/miniconda_3.7.3/pkgs/xlrd-1.1.0-py35_0/lib/python3.5/site-packages/xlrd"
can anyone help me in how to call the xlrd package and eventually get me out of specified Import Error above?
ImportError: No module named xlrd
Then I looked at where Python is reading from by entering the following commands
import sys
print sys.path
['', '/opt/miniconda/current/lib/python27.zip', '/opt/miniconda/current/lib/python2.7', '/opt/miniconda/current/lib/python2.7/plat-linux2', '/opt/miniconda/current/lib/python2.7/lib-tk', '/opt/miniconda/current/lib/python2.7/lib-old', '/opt/miniconda/current/lib/python2.7/lib-dynload', '/opt/miniconda/current/lib/python2.7/site-packages', '/opt/miniconda/current/lib/python2.7/site-packages/setuptools-15.0-py2.7.egg']
but, xlrd package is in the location "/opt//projects/software/miniconda_3.7.3/pkgs/xlrd-1.1.0-py35_0/lib/python3.5/site-packages/xlrd"
can anyone help me in how to call the xlrd package and eventually get me out of specified Import Error above?