from openpyxl import load_workbook
def find_word(excelPath, sheetName, keyword):
wb = load_workbook(excelPath)
ws = wb[sheetName]
for row in ws.iter_rows(max_col=28):
for cell in row:
if cell.value:
if keyword in cell.value:
print(cell.coordinate) # 所在单元格 例:A1
return cell.coordinate
return False
python查找某个值所在的单元格位置
最新推荐文章于 2024-07-25 03:57:33 发布