write float to Excel with pyExcelerator write

Cyril.Liu terry6394 at gmail.com
Sat Mar 1 01:59:56 EST 2008


I use pyExcelerator to generat Excel files in my project. it works good
before I found this bug:
run this code:

from pyExcelerator import *
wb = Workbook()
ws = wb.add_sheet("sheet")
for i  in xrange(1):
    ws.write(i,0, 10474224.6)
wb.save(r'd:\error_float.xls')

open d:\error_float.xls with M$ Excle you'll find the number in the cell is
-263193.64 not 10474224.6


why? some body help me please.
PS: I'm not good at English, I hope you can understand what i said. :)
Thx
-- 
About Cyril.Liu
-----------------------------------
Cyril
ÊÇÒ»¸ö³ÌÐòÔ±,
ÏÖÔÚÊǸöÇî¹âµ°,
Ëû³£³£¸ú×Ô¼ºËµ:"ÎÒ†ÕÒ»‚€ÓÐÀíÏë†þ΁ţ×Ð×Ð"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080301/d07adec2/attachment.html>


More information about the Python-list mailing list