import pyautogui import time import openpyxl

打开Excel文件

workbook = openpyxl.load_workbook(r'C:\Users\Administrator\Desktop\照片查询.xlsx')

选择Sheet1工作表

sheet = workbook['Sheet1']

获取H列的所有单元格内容

column_h = sheet['H']

遍历每个单元格并输出内容

for cell in column_h: print(cell.value)

点击图片

def click_image(image_path): location = pyautogui.locateOnScreen(image=image_path) pyautogui.click(location) time.sleep(1)

点击图片1

click_image(r'C:\Users\Administrator\Desktop\1.png')

点击图片2

click_image(r'C:\Users\Administrator\Desktop\2.png')

点击图片3

click_image(r'C:\Users\Administrator\Desktop\3.png')

获取当前鼠标位置

current_position = pyautogui.position()

粘贴数字到当前鼠标位置

pyautogui.hotkey('ctrl', 'v')

点击图片4

click_image(r'C:\Users\Administrator\Desktop\4.png')

判断是否已经采集

time.sleep(1) if pyautogui.locateOnScreen(r'C:\Users\Administrator\Desktop\6.png') is not None: # 已经采集 pass else: # 未采集，写入表格中 sheet['R' + str(current_position.y)] = '未采集'

点击图片5

click_image(r'C:\Users\Administrator\Desktop\5.png')

保存Excel文件

workbook.save(r'C:\Users\Administrator\Desktop\照片查询.xlsx')