Python:在整个excel工作表中查找值/数据

import pandas as pd

# 加载Excel文件到DataFrame
df = pd.read_excel('path_to_excel_file.xlsx')

# 在整个工作表中查找值
value = '要查找的值'
result = df[df == value].dropna(how='all')

# 打印结果
print(result)

from openpyxl import load_workbook

# 加载Excel文件
wb = load_workbook('path_to_excel_file.xlsx')

# 获取工作表
sheet = wb.active

# 在整个工作表中查找值
value = '要查找的值'
result = []
for row in sheet.iter_rows():
    for cell in row:
        if cell.value == value:
            result.append(cell)

# 打印结果
for cell in result:
    print(cell.coordinate, cell.value)