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_wo rksheet('first' )
>>worksheet.wri te([3,3], "Hello doc !")
>>worksheet.wri te_comment([3,3], "I'm hunting for a wabbit")

0

>>workbook.clos e()

--------
Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
135
unknown3 = pack("<H", -2)
DeprecationWarn ing: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
135
unknown3 = pack("<H", -2)
DeprecationWarn ing: 'H' format requires 0 <= number <= 65535

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
141
sbd_startblock = pack("<L", -2)
DeprecationWarn ing: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
142
unknown7 = pack("<LLL", 0x00, -2 ,0x00)
DeprecationWarn ing: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
143
unused = pack("<L", -1)
DeprecationWarn ing: struct integer overflow masking is deprecated

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

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

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

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

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
168
marker = pack("<L", -3)
DeprecationWarn ing: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
169
end_of_chain = pack("<L", -2)
DeprecationWarn ing: struct integer overflow masking is deprecated

Warning (from warnings module):
File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
170
unused = pack("<L", -1)
DeprecationWarn ing: struct integer overflow masking is deprecated

>>>

[John Machin]

Re: pyXLWriter warnings

On Sep 30, 9:09 am, Robert Singer <rsinger@____.c omwrote:

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_wo rksheet('first' )
>worksheet.writ e([3,3], "Hello doc !")
>worksheet.writ e_comment([3,3], "I'm hunting for a wabbit")

0

>workbook.close ()

>
--------
Warning (from warnings module):
  File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
135
    unknown3 = pack("<H", -2)
DeprecationWarn ing: struct integer overflow masking is deprecated
>
Warning (from warnings module):
  File "C:\Python25\li b\site-packages\pyXLWr iter\OLEWriter. py", line
135
    unknown3 = pack("<H", -2)
DeprecationWarn ing: '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