Python自动化：利用pyautogui实现图片识别和Excel操作

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']

# 点击图片
def click_image(image_path):
    location = pyautogui.locateOnScreen(image=image_path)
    pyautogui.click(location)
    time.sleep(1)

# 粘贴数字到当前鼠标位置
def paste_number(number):
    pyautogui.click(current_position)
    pyautogui.hotkey('ctrl', 'v')
    time.sleep(1)

# 遍历每个单元格
for cell in column_h:
    print(cell.value)

    # 获取当前鼠标位置
    current_position = pyautogui.position()

    # 粘贴学号到当前位置
    paste_number(cell.value)

    # 点击图片4
    click_image(r'C:\Users\Administrator\Desktop\4.png')

    # 判断是否已经采集
    if pyautogui.locateOnScreen(r'C:\Users\Administrator\Desktop\6.png'):
        print('已采集')
    else:
        # 在R列对应的单元格中写入'未采集'
        cell = sheet.cell(row=column_h.index(cell) + 1, column=18)
        cell.value = '未采集'

    # 点击图片5
    click_image(r'C:\Users\Administrator\Desktop\5.png')

# 保存Excel文件
workbook.save(r'C:\Users\Administrator\Desktop\照片查询.xlsx')