python-pyautogui用于采购协同平台SRM自动化创建送货单及接收

import openpyxl
import pyautogui
import pyperclip
import time
pyautogui.FAILSAFE =True
pyautogui.PAUSE = 1
def chuangjian( ):
    pyautogui.click(pyautogui.locateOnScreen('gongzuotai.png', confidence=0.8))
    pyautogui.click(pyautogui.locateOnScreen('songhuodanchuangjian.png', confidence=0.8))
    pyautogui.click(pyautogui.locateOnScreen('chongzhi.png', confidence=0.8))
    pyautogui.doubleClick(pyautogui.moveRel(-370, 0, duration=0.1))  # 订单号位置双击鼠标
    pyautogui.hotkey('ctrl', 'v')
    pyautogui.click(pyautogui.locateOnScreen('chaxun.png', confidence=0.7))  #鼠标点击查询键
    time.sleep(2)
    try:
        zanwushuju = pyautogui.locateOnScreen('zanwushuju.png', confidence=0.9)  # 识图
    except Exception as e:
        print("ERROR:未找到对应图标")
        try:
            duoye_pos = pyautogui.locateOnScreen('duoye.png', confidence=0.8)
            if duoye_pos:
                pyautogui.click(duoye_pos)
                pyautogui.click(pyautogui.locateOnScreen('yema10.png', confidence=0.8))
                pyautogui.click(pyautogui.locateOnScreen('yema100.png', confidence=0.8))
                time.sleep(1)
            else:
                print("duoye not found.")
        except pyautogui.ImageNotFoundException:
            print("Image not found duoye")
        pyautogui.click(pyautogui.locateOnScreen('xuhao1.png', confidence=0.7)) #序号勾选
        time.sleep(1)
        pyautogui.click(pyautogui.locateOnScreen('chuangjiansonghuodan.png', confidence=0.8))
        time.sleep(25)
        pyautogui.click(pyautogui.locateOnScreen('tijiao.png', confidence=0.9))  # 鼠标点击提交键
        pyautogui.click(pyautogui.locateOnScreen('queding.png', confidence=0.7))  # 鼠标点击确定键
        time.sleep(35)
        if "Image not found duoye":
            time.sleep(2)
        else:
            time.sleep(35)
        print('创建完成')
    finally:
        print('暂无数据')
def jieshou( ):
    pyautogui.click(pyautogui.locateOnScreen('gongzuotai.png', confidence=0.8))
    pyautogui.click(pyautogui.locateOnScreen('jieshou.png', confidence=0.8))
    pyautogui.click(pyautogui.locateOnScreen('chongzhi.png', confidence=0.8))
    pyautogui.doubleClick(pyautogui.moveRel(-770, 0, duration=0.1))  # 订单号位置双击鼠标
    pyautogui.hotkey('ctrl', 'v')
    pyautogui.click(pyautogui.locateOnScreen('chaxun.png', confidence=0.7))  #鼠标点击查询键
    time.sleep(2)
    try:
        zanwushuju = pyautogui.locateOnScreen('zanwushuju.png', confidence=0.9)  # 识图
    except Exception as e:
        print("ERROR:未找到对应图标")
        try:
            duoye_pos = pyautogui.locateOnScreen('duoye.png', confidence=0.8)
            if duoye_pos:
                pyautogui.click(duoye_pos)
                pyautogui.click(pyautogui.locateOnScreen('yema10.png', confidence=0.8))
                pyautogui.click(pyautogui.locateOnScreen('yema100.png', confidence=0.8))
                time.sleep(1)
            else:
                print("duoye not found.")
        except pyautogui.ImageNotFoundException:
            print("Image not found duoye.")
        pyautogui.click(pyautogui.locateOnScreen('xuhao1.png', confidence=0.7))  # 序号勾选
        time.sleep(1)
        pyautogui.click(pyautogui.locateOnScreen('jieshouyulan.png', confidence=0.7))  # 鼠标点击创建送货单
        time.sleep(3)
        pyautogui.click(pyautogui.moveRel(0, 50, duration=0.1))
        pyautogui.scroll(-600)
        try:
            duoye_pos = pyautogui.locateOnScreen('duoye.png', confidence=0.7)
            if duoye_pos:
                pyautogui.click(duoye_pos)
                pyautogui.click(pyautogui.locateOnScreen('yema10.png', confidence=0.7))
                pyautogui.click(pyautogui.locateOnScreen('yema100.png', confidence=0.8))
                time.sleep(1)
                pyautogui.scroll(300)
            else:
                print("duoye not found.")
        except pyautogui.ImageNotFoundException:
            print("Image not found duoye")
        pyautogui.click(pyautogui.locateOnScreen('xuhao1.png', confidence=0.7))  # 序号勾选
        time.sleep(1)
        pyautogui.click(pyautogui.locateOnScreen('jieshouguozhang.png', confidence=0.7))  # 鼠标点击提交键
        if "Image not found duoye":
            time.sleep(2)
        else:
            time.sleep(35)
        print('接收完成')
    finally:
        print('暂无数据')

wb = openpyxl.load_workbook('收货订单号.xlsx')  # 获取工作簿(excel文件)对象
ws = wb.active
rows = ws.max_row  # 查看有多少行
for i in range(43, rows + 1):  # 读取第2行第1列开始往后的表格数据
    cell_value = ws.cell(row=i, column=1).value
    print(cell_value)
    pyperclip.copy(cell_value)
    chuangjian()
    jieshou()