擅长:python、mysql、java
<p>我看了这个答案就知道了大部分问题:</p>
<p><a href="https://stackoverflow.com/a/15004956/9649146">https://stackoverflow.com/a/15004956/9649146</a></p>
<p>我最后得到的代码是:</p>
<p/><div^{cl1}$&13;
<div^{cl2}$&13;
<pre class="snippet-code-js lang-js prettyprint-override"><code>import openpyxl
wb = openpyxl.load_workbook(filename=r'C:\Users\.spyder-py3\data\AAXN.xlsx')
ws = wb.worksheets[0]
r = 2
for row in ws.iter_rows('G{}:G{}'.format(ws.min_row,ws.max_row)):
for cell in row:
ws.cell(row=r, column=7).value = 'AAXN'
r += 1
wb.save(r'C:\Users\.spyder-py3\data\AAXN.csv')
wb.close()</code></pre>
;
</div>和13;
</div>和13;