import os
from pprint import pprint
from openpyxl import load_workbook
path = r'C:\Users\Desktop\test'
# 搜索关键字
keyword1 = '顧客'
keyword2 = '仕入先'
keyword3 = '発注'
keyword4 = '最終'
for root, dirs, files in os.walk(path):
for file_name in files:
if file_name.endswith('xlsx'):
# 加载Excel文件
workbook = load_workbook(os.path.join(root, file_name))
# 遍历所有工作表
for sheetname in workbook.sheetnames:
worksheet = workbook[sheetname]
# 遍历所有单元格
for row in worksheet.iter_rows():
for cell in row:
# 查询关键字段
if keyword1 in str(cell.value) or keyword2 in str(cell.value) \
or keyword3 in str(cell.value) or keyword4 in str(cell.value):
# 打印单元格内容和位置
print(f"{cell.value} {file_name}")
# 关闭Excel文件
workbook.close()