擅长:python、mysql、java
<p>对于openpyxl版本2.6.2:
注意,float显示取决于在python shell、idle或ipython会话中的大小</p>
<pre><code>>>> wb = load_workbook('tmp.xlsx')
>>> ws = wb[wb.sheetnames[0]]
>>> c21 = ws.cell(2,1)
>>> c21.value
'43546'
>>> c21.value = int(c21.value)
>>> c21.value
43546
>>> c21.value = 134352345235253235.235235
>>> c21.number_format = '0.000E+00'
>>> c21.value
1.3435234523525323e+17
>>> c21.value = 534164134.6643
>>> c21.value
534164134.6643
>>> wb.save('tmp_a.xlsx')
>>> wb.close()
</code></pre>
<p>但不要失望,因为当您使用MS Excel或LibreOffice Calc或Gnumeric重新打开电子表格时,“0.000E+00”格式将正确显示。请记住保存工作簿。</p>