ImportError: No module named xlsxwriter

python-2.7 xlsxwriter
pwned555 picture pwned555 · Dec 9, 2014 · Viewed 131.4k times · Source

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.

Answer

byteC0de picture byteC0de · Dec 17, 2015

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.

Related questions

how to add border to a range of cells using xlsxwriter?

I want to add border around a range of cells like this image1, but my output file looks like this when I applied "set_column" function image2. instead of "set_column", is there any other functions to use? writer=pd.…

Read More
XlsxWriter: set_column() with one format for multiple non-continuous columns

I want to write my Pandas dataframe to Excel and apply a format to multiple individual columns (e.g., A and C but not B) using a one-liner as such: writer = pd.ExcelWriter(filepath, engine='xlsxwriter') my_format = writer.book.…

Read More
Iterating over dictionaries using 'for' loops

I am a bit puzzled by the following code: d = {'x': 1, 'y': 2, 'z': 3} for key in d: print key, 'corresponds to', d[key] What I don't understand is the key portion. How does Python recognize that it needs only to …

Read More