擅长:python、mysql、java
<p>传递给目标单元格的值应该是单个字符串。因此:</p>
<pre><code>wksTarget.cell(row = i, column = 1).value = '{}\n{}'.format(name, family)
</code></pre>
<p>应该没问题。这就是我的全部代码:</p>
<pre><code>import openpyxl as xl
import os
wbSource = xl.load_workbook(os.path.dirname(os.path.realpath(__file__)) + '\myExcel.xlsx')
wksSourse = wbSource['Sheet1']
wbTarget = xl.load_workbook(os.path.dirname(os.path.realpath(__file__)) + '\Target.xlsx')
wksTarget = wbTarget['Sheet1']
for i in range (1, wksSourse.max_row+1):
name = wksSourse.cell(row = i, column = 1).value
family = wksSourse.cell(row = i, column = 2).value
wksTarget.cell(row = i, column = 1).value = '{}\n{}'.format(name, family)
wbTarget.save(os.path.dirname(os.path.realpath(__file__)) + '\Target.xlsx')
wbTarget.close()
</code></pre>