xlutils 1.5.2

Utilities for working with Excel files that require both xlrd and xlwt

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

Utility functions for displaying information about xlrd-related objects in a user-friendly and safe fashion.

xlutils.filter

A mini framework for splitting and filtering Excel files into new Excel files.

xlutils.margins

Tools for finding how much of an Excel file contains useful data.

xlutils.save

Tools for serializing xlrd.Book objects back to Excel files.

xlutils.styles

Tools for working with formatting information expressed in styles.

Installation

The easyiest way to install xlutils is:

easy_install xlutils

Or, if you’re using zc.buildout, just specify ‘xlutils’ as a required egg.

However, you can also install in the usual python fashion of unpacking the source distribution and running:

python setup.py install

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 PYTHONPATH:

• xlrd

  You’ll need version 0.6.1a1 or later. Latest versions can be found here:

  http://pypi.python.org/pypi/xlrd

• xlwt

  You’ll need version 0.7.0 or later. Latest versions can be found here:

  http://pypi.python.org/pypi/xlwt

• errorhandler

  This can be found here:

  http://pypi.python.org/pypi/errorhandler

If you’re installing with either easy_install or buildout, these dependencies will automatically be installed for you.