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