On Sep 30, 9:09 am, Robert Singer <[EMAIL PROTECTED]> 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 -- http://mail.python.org/mailman/listinfo/python-list
