Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.

Avoids errors like these when processing Django messages with xgettext:

xgettext: ./env/lib/python2.7/site-packages/xlwt/Bitmap.py:1: Unknown encoding "windows-1251". Proceeding with ASCII instead.
xgettext: ./env/lib/python2.7/site-packages/xlwt/Cell.py:1: Unknown encoding "windows-1252". Proceeding with ASCII instead.
xgettext: ./env/lib/python2.7/site-packages/xlwt/Column.py:1: Unknown encoding "windows-1252". Proceeding with ASCII instead.
xgettext: ./env/lib/python2.7/site-packages/xlwt/CompoundDoc.py:1: Unknown encoding "windows-1252". Proceeding with ASCII instead.
xgettext: Non-ASCII string at ./env/lib/python2.7/site-packages/xlwt/CompoundDoc.py:209.
          Please specify the source encoding through --from-code.

Following discussion on PR #32, this adds Python 3 support without any external dependencies. Python 2.6 and above and Python 3.3 and above should work; older versions will not.

The tests are passing on Python 2 and 3; I haven't tried the examples.

Hi John,

I have patched xlwt to support Python 3.3 as well as Python 2.6/2.7 with a single codebase (i.e. no embedded 2to3 conversion).

This currently introduces one dependency: my future package for Py2/3 compatibility.

I would be interested in your feedback. The patch set is big but most of the changes should be uncontroversial (e.g. converting print statements to print functions). The unicode / bytes disambiguation was the most difficult part.

It seems to work now under both Python 3.3 and Python 2.7 for all the example scripts, but this could do with more testing.

Kind regards, Ed Schofield ([email protected])

Include license file in source distribution by using MANIFEST.in.

Include license file in the generated wheel package. The wheel package format supports including the license file. This is done using the [metadata] section in the setup.cfg file. For additional information on this feature, see:

https://wheel.readthedocs.io/en/stable/index.html#including-the-license-in-the-generated-wheel-file

This patch adds a new 'insert_bitmap_data' function on the Worksheet to complement the 'insert_bitmap' function. As the existing 'insert_bitmap' function depends on a filename as one if it's arguments, the new function allows programs that have a copy of the bitmap in memory to add it to the worksheet without first having to write it to file.

Adds tests from Manfred Moitzi's xlwt3 port, and gets them passing with xlwt on Python 2.

Don't merge this until Manfred has agreed to relicense the tests, as they currently say GPL3 at the top of each file. He agreed to do this for the xlrd tests, and I've emailed him about it, so I'm optimistic that he'll OK that soon.

I put together some tests to aid in porting to Python 3. Hopefully they're a good starting point. Feedback from those better acquainted with the code would be appreciated. I attempted to make them so that they'll work in both 2 and 3.

I ran into this problem when learning how to use xlwt. Currently it throws an unhelpful index error:

import xlwt wb=xlwt.Workbook() wb.save("/tmp/test.xls") Traceback (most recent call last): File "", line 1, in File "/usr/local/lib/python2.7/dist-packages/xlwt/Workbook.py", line 710, in save doc.save(filename_or_stream, self.get_biff_data()) File "/usr/local/lib/python2.7/dist-packages/xlwt/Workbook.py", line 680, in get_biff_data self.__worksheets[self.__active_sheet].selected = True IndexError: list index out of range

I couldn't find a way to set the height of a row to a fixed value independent from the font height in the current version of the API, so I added a small method to the Row class which does that.

Hi, This pull request is referent to #66, that was closed due lack of feedback. I've made the changes that you requested. Sorry, but I was working in another project.