pyXLWriter warnings

[Robert Singer]

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

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
141
sbd_startblock = pack("<L", -2)
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
142
unknown7 = pack("<LLL", 0x00, -2 ,0x00)
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
143
unused = pack("<L", -1)
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
205
pps_prev = pack("<L", -1) #0x44
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
206
pps_next = pack("<L", -1) #0x48
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
213
pps_sb = pack("<L", sb) #0x74
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
207
pps_dir = pack("<L", dir) #0x4c
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
168
marker = pack("<L", -3)
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
169
end_of_chain = pack("<L", -2)
DeprecationWarning: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\lib\site-packages\pyXLWriter\OLEWriter.py", line
170
unused = pack("<L", -1)
DeprecationWarning: struct integer overflow masking is deprecated

 

[John Machin]

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