Python - How can I install xlutils?

xlutils python
xlrd python
install xlrd python 3
xlrd xlwt
install xlwt in ubuntu
xlrd version python
python xlrd wheel
unresolved import xlwt

I am using Python 2.5 (and need to stay with that) and have already downloaded xlrd 0.8.0 and xlwt 0.7.2, and they both seem to be working OK.

I will be needing to read from and write to Excel spreadsheets, and so believe I will need to add xlutils as well. The problem is, I can't install it so far.

I have pip and tried the simple:

pip install xlutils

That ran and downloaded xlutils, but got hung up with:

Downloading/unpacking xlutils
  Downloading xlutils-1.6.0.tar.gz (54Kb): 54Kb downloaded
  Running setup.py egg_info for package xlutils
Downloading/unpacking xlrd>=0.7.2 (from xlutils)
  Downloading xlrd-0.9.2.tar.gz (167Kb): 167Kb downloaded
  Running setup.py egg_info for package xlrd
    Traceback (most recent call last):
      File "<string>", line 14, in <module>
      File "C:\Python25\Lib\site-packages\xlutils-1.6.0\build\xlrd\setup.py", li
ne 8, in <module>
        raise Exception("This version of xlrd requires Python 2.6 or above. "
    Exception: This version of xlrd requires Python 2.6 or above. For older versions of Python, you can use the 0.8 series.
... [snipping some]
----------------------------------------
Command python setup.py egg_info failed with error code 1 in C:\Python25\Lib\sit
e-packages\xlutils-1.6.0\build\xlrd

So then I figured it was trying to download a newer xlrd (which I can't use with Python 2.5) and since I already have xlrd installed, it breaks on that.

I then tried to just download xlutils from https://pypi.python.org/pypi/xlutils, and then unzipped it with 7zip, put the xlutils folder under Python25>Lib>site-packages, cd'd there, and did:

python setup.py install

but that gives me this error in the cmd window:

C:\Python25\Lib\site-packages\xlutils-1.6.0>python setup.py install
Traceback (most recent call last):
  File "setup.py", line 5, in <module>
    from setuptools import setup
ImportError: No module named setuptools

So how can I install this?

First of all, you do not need xlutils just to read and write Excel files. You can read them with xlrd and write them with xlwt and provide your own "glue" in the Python code that you write yourself.

That said, xlutils does provide features that make some things more convenient than writing them for yourself (that is the point of its existence). So the second part of my answer is: You do not need to "install" xlutils per se. You can just unpack it and put the xlutils directory into site-packages and be off and running. This is true for pretty much every pure-Python package, as far as I know. (Some other packages are partially written in C (or sometimes other languages) and these often require specific installation steps.) So why do pure-Python packages provide a setup.py script? Usually to run tests or to build .pyc files, both of which are optional.

Python - How can I install xlutils?, Utilities for working with Excel files that require both xlrd and xlwt. However, you can also install in the usual python fashion of unpacking the source  I am using Python 2.5 (and need to stay with that) and have already downloaded xlrd 0.8.0 and xlwt 0.7.2, and they both seem to be working OK. I will be needing to read from and write to Excel

xlutils 1.4.1 is compatible with python 2.5. So this should work:

pip install xlutils==1.4.1

Installation Instructions, So the second part of my answer is: You do not need to "install" xlutils per se. You can just unpack it and put the xlutils directory into site-packages and be off and running. This is true for pretty much every pure-Python package, as far as I know. xlutils. This package provides a collection of utilities for working with Excel files. Since these utilities may require either or both of the xlrd and xlwt packages, they are collected together here, separate from either package. Currently available are: xlutils.copy Tools for copying xlrd.Book objects to xlwt.Workbook objects. xlutils.display

Try install python-setuptools package.

In Debian: sudo apt-get install python-setuptools

For 3.x version

sudo apt-get install python3-setuptools

Installing xlutils alongside xlrd and xlwt in ArcPy install folder to , buildout , just specify xlutils as a required egg. If you do not install using easy_install or zc.buildout, you will also need to make sure the following python packages  You can read them with xlrd and write them with xlwt and provide your own “glue” in the Python code that you write yourself. That said, xlutils does provide features that make some things more convenient than writing them for yourself (that is the point of its existence).

pip3 install xlutils

Using pip3 instead of pip solved it for me.

Xlutils :: Anaconda Cloud, You can install from pypi using pip: pip install --user xlutils. http://pythonhosted.​org/xlutils/installation.html. If pip.exe is not in your PATH use the  xlutils This package provides a collection of utilities for working with Excel files. Since these utilities may require either or both of the xlrd and xlwt packages, they are collected together here, separate from either package.

[PDF] xlutils Documentation, conda install. linux-ppc64le v2.0.0; linux-64 v2.0.0; win-32 v2.0.0; osx-64 v2.0.0; linux-32 v2.0.0; win-64 v2.0.0. To install this package with conda run: xlutils documentation¶ This package provides a collection of utilities for working with Excel files. Since these utilities may require either or both of the xlrd and xlwt packages, they are collected together here, separate from either package.

Python - Python working with Excel. how to install xlutils?, If you do not install using easy_install or zc.buildout, you will also need to make sure the following python packages are available on your  The following are code examples for showing how to use xlutils.copy.copy(). They are extracted from open source Python projects. You can vote up the examples you like or vote down the ones you don't like. You can also save this page to your account.

Python 3.3 install xlutils, >ImportError: No module named setuptools >ImportError: No module named setuptools >ImportError: No module named setuptools. Ah, what could it be? The first problem that arises in working with spreadsheets using Python is because of these two different extensions. The package xlwt supports the .xls extension of Excel, and openpyxl supports the .xlsx extensions of Excel. I will be demonstrating how to use the xlwt package for working with spreadsheets.

Comments
  • use virtualenv and use a decent version of python!
  • Great, just putting it there does work. I've never quite known why I couldn't do this in most cases, and you've answered that. Also, thanks for the point about needing xlutils. Great answer overall.
  • Thanks, but I just tried that (correcting the typo to xlutils not xlutis) but got the same error: "Exception: This version of xlrd requires Python 2.6 or above. For older versions of Python, you can use the 0.8 series."
  • That's because you are still having the new version. Try uninstalling xlutils first with 'pip uninstall xlutils' and installing it again.
  • I tried that, it didn't work. And I don't think it ever got installed, since I can't import it. In any case, I'm going to just put the folder there myself, as in John Y's answer.