如何使用Python遍历Excel表格的行或列，并在单元格中查找特定值？

pip install openpyxl

import openpyxl

# 打开Excel文件
workbook = openpyxl.load_workbook('example.xlsx')

# 选择要操作的表格
sheet = workbook['Sheet1']

# 遍历行
for row in sheet.iter_rows(min_row=1, max_row=sheet.max_row):
    # 遍历列
    for cell in row:
        # 判断单元格的值是否等于特定值
        if cell.value == '特定值':
            print("在单元格", cell.coordinate, "中找到特定值")

# 遍历列
for column in sheet.iter_cols(min_col=1, max_col=sheet.max_column):
    # 遍历行
    for cell in column:
        # 判断单元格的值是否等于特定值
        if cell.value == '特定值':
            print("在单元格", cell.coordinate, "中找到特定值")

# 关闭Excel文件
workbook.close()