pyXLWriter warnings

[John Machin]

On Sep 30, 9:09 am, Robert Singer <rsinger at ____.com> wrote:
> Platform: winXP, excel 2003
> Python 2.5.2
> XLWriter 0.4a3 (http://sourceforge.net/projects/pyxlwriter/)
>
> Is anyone here using this very nice package, for writing excel files?
> I'm using it on python 2.5.2. (although it is made for older version
> of python) and cannot find a way to get rid of this error (code and
> errors below).
>
> Does anyone know how to avoid it ? I would appreciate all help and
> ideas you can think of.
>
> Bob
> --------
>
> >>> import pyXLWriter as xl
> >>> workbook = xl.Writer("test.xls")
> >>> worksheet = workbook.add_worksheet('first')
> >>> worksheet.write([3,3], "Hello doc !")
> >>> worksheet.write_comment([3,3], "I'm hunting for a wabbit")
> 0
> >>> workbook.close()
>
> --------
> Warning (from warnings module):
>   File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
> 135
>     unknown3 = pack("<H", -2)
> DeprecationWarning: struct integer overflow masking is deprecated
>
> Warning (from warnings module):
>   File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
> 135
>     unknown3 = pack("<H", -2)
> DeprecationWarning: 'H' format requires 0 <= number <= 65535

[big snip of similar messages]

There is not much point in working on pyXLWriter source; the package
is abandonware ** 2. Although I can't find it now, I recall reading a
recommendation from its author (Evgeny Filatov) that its users migrate
to pyExcelerator. Unfortunately pyExcelerator has not been maintained
for some time now. However Chris Withers of Simplistix and I have
created xlwt, a fork of pyExcelerator; Chris is hosting the SVN repo
and I am maintaining it. We now have a public release out of the door
(http://pypi.python.org/pypi/xlwt/).

There is only one task remaining AFAIK to meet the initial goal of
providing the equivalent of (pyExcelerator last released version + all
sensible patches included + all known [and several unknown] bugs fixed
+ an easier way of specifying cell formatting ("easyxf")) -- this is
support for 3D references i.e. to other worksheets in the same
workbook. Christophe Tronche has adapted Ruben Mendes' pyExcelerator
patch to xlwt, and it's currently undergoing testing.

You may like to check out the python-excel newsgroup at
http://groups.google.com/group/python-excel ...

HTH,
John