ImportError No module named xlsxwriter

Question

I recently downloaded the xlsxwriter version 0 6 4 and installed it on my computer   It correctly added it to my C  Python27 Lib site-packages xlsxwriter folder  however when I try to import it I get the error ImportError  No module named xlsxwriter   The traceback is File  F  Working ArcGIS ArcGIS  py Scripts Append Geodatabase py    However if I try to import numpy  I can t remember what numby is  however it is located in the same site-packages folder C  Python27 Lib site-packages numpy  it has no problem   Any idea of what could be causing this issue   Thanks for the help

User · Answer

I managed to resolve this issue as follows...

Be careful, make sure you understand the IDE you're using! - Because I didn't. I was trying to import xlsxwriter using PyCharm and was returning this error.

Assuming you have already attempted the pip installation (sudo pip install xlsxwriter) via your cmd prompt, try using another IDE e.g. Geany - & import xlsxwriter.

I tried this and Geany was importing the library fine. I opened PyCharm and navigated to 'File>Settings>Project:>Project Interpreter' xlslwriter was listed though intriguingly I couldn't import it! I double clicked xlsxwriter and hit 'install Package'... And thats it! It worked!

Hope this helps...

User · Answer

I installed it by using a wheel file that can be found at this location  https   pypi org project XlsxWriter  files  I then ran pip install  XlsxWriter-1 2 8-py2 py3-none-any whl        Processing   XlsxWriter-1 2 8-py2 py3-none-any whl   Installing collected packages  XlsxWriter   Successfully installed XlsxWriter-1 2 8

User · Answer

I have the same issue  It seems that pip is the problem  Try   pip uninstall xlsxwriter easy install xlsxwriter

User · Answer

I am not sure what caused this but it went all well once I changed the path name from Lib into lib and I was finally able to make it work

User · Answer

Here are some easy way to get you up and running with the XlsxWriter module The first step is to install the XlsxWriter module The pip installer is the preferred method for installing Python modules from PyPI  the Python Package Index       sudo pip install xlsxwriter   Note  Windows users can omit sudo at the start of the command

User · Answer

Even if it looks like the module is installed  as far as Python is concerned it isn t since it throws that exception  Try installing the module again using one of the installation methods shown in the XlsxWriter docs and look out for any installation errors  If there are none then run a sample program like the following  import xlsxwriter  workbook   xlsxwriter Workbook  hello xlsx   worksheet   workbook add worksheet    worksheet write  A1    Hello world    workbook close

[python-2.7] ImportError: No module named xlsxwriter

Examples related to python-2.7

Examples related to xlsxwriter