[prev in list] [next in list] [prev in thread] [next in thread] 

List:       python-list
Subject:    write float to Excel with pyExcelerator write
From:       "Cyril.Liu" <terry6394 () gmail ! com>
Date:       2008-02-29 15:53:55
Message-ID: 6d2d06b10802290753q22d12a3g342504ac3ac0d48a () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

[Attachment #4 (text/plain)]

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
是一个程序员,
现在是个穷光蛋,
他常常跟自己说:"我喺一個有理想嘅蝸牛仔仔"

[Attachment #5 (text/html)]

I use pyExcelerator to generat Excel files in my project. it works good before I \
found this bug:<br>run this code:<br><br style="color: rgb(51, 51, 51);"><span \
style="color: rgb(51, 51, 255);">from pyExcelerator import *</span><br style="color: \
rgb(51, 51, 255);"> <span style="color: rgb(51, 51, 255);">wb = Workbook()</span><br \
style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">ws = \
wb.add_sheet(&quot;sheet&quot;)</span><br style="color: rgb(51, 51, 255);"><span \
style="color: rgb(51, 51, 255);">for i&nbsp; in xrange(1):</span><br style="color: \
rgb(51, 51, 255);"> <span style="color: rgb(51, 51, 255);">&nbsp;&nbsp;&nbsp; \
ws.write(i,0, 10474224.6)</span><br style="color: rgb(51, 51, 255);"><span \
style="color: rgb(51, 51, 255);">wb.save(r&#39;d:\error_float.xls&#39;)</span><br><br \
clear="all">open d:\error_float.xls with M$ Excle you&#39;ll find the number in the \
cell is <span style="color: rgb(255, 0, 0);">-263193.64 <font color="#000000">not \
10474224.6<br> <br><br>why? some body help me please.<br>PS: I&#39;m not \
good</font></span> at English, I hope you can understand what i said. :)<br>Thx<span \
style="color: rgb(51, 51, 255);"></span><br>-- <br>About \
Cyril.Liu<br>-----------------------------------<br> \
Cyril<br>是一个程序员,<br>现在是个穷光蛋,<br>他常常跟自己说:&quot;我喺一個有理想嘅蝸牛仔仔&quot;<br>




-- 
http://mail.python.org/mailman/listinfo/python-list

[prev in list] [next in list] [prev in thread] [next in thread]