擅长:python、mysql、java
<p>这个答案适用于openpyxl 2.0。(不是<a href="https://stackoverflow.com/a/12401556/119775">previously accepted answer</a>。)</p>
<p>可以直接更改<code>number_format</code>。</p>
<p>给定的示例变成:</p>
<pre><code>from openpyxl import Workbook
wb = Workbook()
ws = wb.create_sheet(title='testSheet')
_cell = ws.cell('A1')
_cell.number_format = '0.00E+00'
</code></pre>