擅长:python、mysql、java
<p>使用<code>in</code>关键字和<a href="https://www.w3schools.com/python/python_strings.asp" rel="nofollow noreferrer">replace method</a></p>
<pre class="lang-py prettyprint-override"><code>import openpyxl
wb = openpyxl.load_workbook("sourcefile.xlsx")
ws = wb["sheet1"]
i = 0
for r in range(1,ws.max_row+1):
for c in range(1,ws.max_column+1):
s = ws.cell(r,c).value
if s != None and "hello" in s:
ws.cell(r,c).value = s.replace("hello","hi")
print("row {} col {} : {}".format(r,c,s))
i += 1
wb.save('targetfile.xlsx')
print("{} cells updated".format(i))
</code></pre>
<p>如果需要不区分大小写的搜索/替换或更复杂的匹配,可以使用<a href="https://www.w3schools.com/python/python_regex.asp" rel="nofollow noreferrer">regular expression</a>。添加<code>import #re</code>并使用</p>
<pre class="lang-py prettyprint-override"><code>if s != None and re.search('hello',s,flags=re.I):
ws.cell(r,c).value = re.sub('hello',"Hi",s,flags=re.I)
</code></pre>