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

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

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

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

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 -  amp  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

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

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

[python-2.7] ImportError: No module named xlsxwriter

Examples related to python-2.7

Examples related to xlsxwriter