Python自动化采集照片并判断状态

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)

点击图片4

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

获取当前鼠标位置

current_position = pyautogui.position()

循环操作

for i in range(2, len(column_h)): # 将学号粘贴到当前位置 pyautogui.typewrite(str(sheet['H' + str(i)].value))

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

# 判断是否已经采集
if pyautogui.locateOnScreen(r'C:\Users\Administrator\Desktop\6.png'):
    # 如果已经采集，则不需要写入'未采集'
    pass
else:
    # 如果未采集，则在表格中R列对应的单元格中写入'未采集'
    sheet['R' + str(i)].value = '未采集'
    workbook.save(r'C:\Users\Administrator\Desktop\照片查询.xlsx')

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

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