擅长:python、mysql、java
<p>FWIW openpyxl 2.4使得将Excel工作表的全部或部分转换为Pandas数据框变得非常容易:<code>ws.values</code>是工作表中所有值的迭代器。它还有一个新的<code>ws.iter_cols()</code>方法,允许您直接处理列。</p>
<p>它目前(2016年4月)作为alpha版本提供,可以使用<code>pip install -U --pre openpyxl</code>安装</p>
<p>代码看起来有点像这样:</p>
<pre><code>sheet["B1"] = "firstName"
sheet["C1"] = "middleName"
sheet["D1"] = "lastName"
for row in sheet.iter_rows(min_row=2, max_col=2):
id_cell, name = row
fullname = name.value.strip()
namelist = fullname.split()
firstname = namelist[0]
lastname = namelist[-1]
middlename = ""
if len(namelist) >= 3:
middlename = namelist[1]
if len(namelist) == 4:
lastname = " ".join(namelist[-2:])
if middlename in ('Del', 'El', 'Van', 'Da'):
lastname = " ".join([middlename, lastname])
middlename = None
name.value = firstname
name.offset(column=1).value = middlename
name.offset(column=2).value = lastname
wb.save("output.xlsx")
</code></pre>