ImportError: cannot import name get_column_letter

python python-2.7 module importerror openpyxl
charsi picture charsi · Apr 19, 2016 · Viewed 25.7k times · Source

I am able to use openpyxl as an import in my code. But when I try to do the following:

from openpyxl.cell import get_column_letter

I get the following error:

ImportError: cannot import name get_column_letter

I am using python 2.7. I have installed it using easy_install. Tried searching for this issue but couldn't find anything related to it.

Answer

Abbas picture Abbas · Apr 19, 2016

The function get_column_letter has been relocated in Openpyxl version 2.4 from openpyxl.cell to openpyxl.utils.

The current import is: from openpyxl.utils import get_column_letter

If you want to do not know which version the end-user has, you can use the following code:

try: 
    from openpyxl.cell import get_column_letter
except ImportError:
    from openpyxl.utils import get_column_letter

Related questions

ImportError: No module named pynotify. While the module is installed

So this error keeps coming back. Everytime I try to tun the script it returns saying: Traceback (most recent call last): File "cli.py", line 11, in <module> import pynotify ImportError: No module named pynotify The strange thing is, …

Read More
Python DNS module import error

I have been using python dns module.I was trying to use it on a new Linux installation but the module is not getting loaded. I have tried to clean up and install but the installation does not seem to …

Read More
Python: import module from another directory at the same level in project hierarchy

I've seen all sorts of examples and other similar questions, but I can't seem to find an example that exactly matches my scenario. I feel like a total goon asking this because there are so many similar questions, but I …

Read More