Captain Cretaceous Captain Cretaceous - 3 months ago 21
Python Question

Eclipse XLRD, XLWT Import Error

I downloaded the latest Enthought EPD python distribution (academic), which comes with python 2.7.
I am using Eclipse as my IDE.

Eclipse is set up to use this instance of Python. I ran the "images.py" example file under XLWT.

"images.py":



from xlwt import Workbook
w = Workbook()
ws = w.add_sheet('Image')
ws.insert_bitmap('python.bmp', 0, 0)
w.save('images.xls')


and Eclipse returned:

Traceback (most recent call last):
File "C:\Documents and Settings\Username\workspace\XLRDXLWT\src\xlwt\images.py", line 1, in
<module>
from xlwt import Workbook
ImportError: cannot import name Workbook


Similar problem with any other example I try to run in XLRD, XLUTILS.

Answer

Yes, indeed, "someone" helped you with the answer.

It's nothing to do with xlrd, xlwt, xlutils, or Eclipse.

In general, if you put a script that does import foo into a directory named foo, Python is likely to try to import foo from that directory, and fail.

Solution: Don't do that. Rename your script directory to foo_examples or foo_scripts or suchlike.