import pyautogui
import time
import xlrd
import pyperclip
import time
import os
def mouseClick(clickTimes, lOrR, img, reTry):
def mouseClickAll(clickTimes, lOrR, img, reTry, multi=False):
if reTry == 1:
while True:
# 关键修改：使用 locateAllOnScreen 获取所有匹配位置
locations = list(pyautogui.locateAllOnScreen(img, confidence=0.9))
if locations:
for loc in locations:
center = pyautogui.center(loc)
pyautogui.click(center.x, center.y,
clicks=clickTimes,
interval=0.2,
duration=0.2,
button=lOrR)
# 添加对象间操作间隔
time.sleep(0.9)
break
print("未找到匹配图片，0.1秒后重试")
time.sleep(0.1)
elif reTry == -1:
while True:
location = pyautogui.locateCenterOnScreen(img, confidence=0.9)
if location is not None:
pyautogui.click(location.x, location.y, clicks=clickTimes, interval=0.2, duration=0.2, button=lOrR)
time.sleep(0.1)
elif reTry > 1:
i = 1
while i < reTry + 1:
location = pyautogui.locateCenterOnScreen(img, confidence=0.9)
if location is not None:
pyautogui.click(location.x, location.y, clicks=clickTimes, interval=0.2, duration=0.2, button=lOrR)
print("重复")
i += 1
time.sleep(0.1)
# 定义热键事件
# hotkey_get方法用来判断热键组合个数,还是文字输入。
def hotkey_get(hk_g_inputValue):
try:
newinput = hk_g_inputValue.split(',')
pyautogui.hotkey(*tuple(newinput))
except:
pyperclip.copy(hk_g_inputValue)
pyautogui.hotkey('ctrl', 'v')
# hotkey_get方法用来判断热键组合个数，并把热键传到对应的变量上newinput[0],[1],[2],[3]……[9]只写了10个后续可以添加。【老方法弃用】
# hotkey_Group方法调用hotkey_get方法，并判断其热键内容是否需要循环。
def hotkeyGroup(reTry, hkg_inputValue):
if reTry == 1:
hotkey_get(hkg_inputValue)
print("执行了：", hkg_inputValue)
time.sleep(0.1)
elif reTry == -1:
while True:
hotkey_get(hkg_inputValue)
print("执行了：", hkg_inputValue)
time.sleep(0.1)
elif reTry > 1:
i = 1
while i < reTry + 1:
hotkey_get(hkg_inputValue)
print("执行了：", hkg_inputValue)
i += 1
time.sleep(0.1)
# cmdType.value 1.0 左键单击 2.0 左键双击 3.0 右键单击 4.0 输入 5.0 等待 6.0 滚轮
# 7.0 热键组合（最多4个）
# 8.0 粘贴当前时间
# 9.0 系统命令集
# ctype 空：0
# 字符串：1
# 数字：2
# 日期：3
# 布尔：4
# error：5
def dataCheck(sheet1):
checkCmd = True
# 行数检查
if sheet1.nrows < 2:
print("没数据啊哥")
checkCmd = False
# 每行数据检查
i = 1
while i < sheet1.nrows:
# 第1列 操作类型检查
cmdType = sheet1.row(i)[0]
if cmdType.ctype != 2 or (cmdType.value != 1.0 and cmdType.value != 2.0 and cmdType.value != 3.0
and cmdType.value != 4.0 and cmdType.value != 5.0 and cmdType.value != 6.0
and cmdType.value != 7.0 and cmdType.value != 8.0 and cmdType.value != 9.0):
print('第', i + 1, "行,第1列数据有毛病")
checkCmd = False
# 第2列 内容检查
cmdValue = sheet1.row(i)[1]
# 读图点击类型指令，内容必须为字符串类型
if cmdType.value == 1.0 or cmdType.value == 2.0 or cmdType.value == 3.0:
if cmdValue.ctype != 1:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 输入类型，内容不能为空
if cmdType.value == 4.0:
if cmdValue.ctype == 0:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 等待类型，内容必须为数字
if cmdType.value == 5.0:
if cmdValue.ctype != 2:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 滚轮事件，内容必须为数字
if cmdType.value == 6.0:
if cmdValue.ctype != 2:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 7.0 热键组合，内容不能为空
if cmdType.value == 7.0:
if cmdValue.ctype == 0:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 8.0 时间，内容不能为空
if cmdType.value == 8.0:
if cmdValue.ctype == 0:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
# 9.0 系统命令集模式，内容不能为空
if cmdType.value == 9.0:
if cmdValue.ctype == 0:
print('第', i + 1, "行,第2列数据有毛病")
checkCmd = False
i += 1
return checkCmd
# 任务
def mouseClickAll(clickTimes, lOrR, img, reTry):
if reTry == 1: # 单次尝试
while True:
locations = list(pyautogui.locateAllOnScreen(img, confidence=0.9))
if locations:
print(f"找到 {len(locations)} 个匹配对象")
for loc in locations:
center = pyautogui.center(loc)
pyautogui.click(center.x, center.y,
clicks=clickTimes,
interval=0.2,
duration=0.2,
button=lOrR)
time.sleep(0.1) # 对象间操作间隔
break
print("未找到匹配图片，0.1秒后重试")
time.sleep(0.1)
elif reTry == -1: # 无限重试
while True:
locations = list(pyautogui.locateAllOnScreen(img, confidence=0.9))
if locations:
print(f"找到 {len(locations)} 个匹配对象")
for loc in locations:
center = pyautogui.center(loc)
pyautogui.click(center.x, center.y,
clicks=clickTimes,
interval=0.2,
duration=0.2,
button=lOrR)
time.sleep(0.1)
time.sleep(0.1)
elif reTry > 1: # 指定重试次数
for attempt in range(reTry):
locations = list(pyautogui.locateAllOnScreen(img, confidence=0.9))
if locations:
print(f"尝试 {attempt + 1}/{reTry}: 找到 {len(locations)} 个匹配对象")
for loc in locations:
center = pyautogui.center(loc)
pyautogui.click(center.x, center.y,
clicks=clickTimes,
interval=0.2,
duration=0.2,
button=lOrR)
time.sleep(0.1)
else:
print(f"尝试 {attempt + 1}/{reTry}: 未找到匹配图片")
time.sleep(0.1)
def mainWork(img):
i = 1
while i < sheet1.nrows:
cmdType = sheet1.row(i)[0]
# 获取多对象操作标记（新增第4列）
multi_mode = False
if len(sheet1.row(i)) > 3: # 确保存在第4列
# 处理数字和字符串两种格式
if sheet1.row(i)[3].ctype == 2: # 数字类型
multi_mode = bool(sheet1.row(i)[3].value)
elif sheet1.row(i)[3].ctype == 1: # 字符串类型
multi_mode = str(sheet1.row(i)[3].value).lower() in ['1', 'true', 'yes', '多对象']
if cmdType.value == 1.0: # 左键单击
img = sheet1.row(i)[1].value
reTry = 1
if sheet1.row(i)[2].ctype == 2 and sheet1.row(i)[2].value != 0:
reTry = sheet1.row(i)[2].value
if multi_mode:
mouseClickAll(clickTimes=1, lOrR='left', img=img, reTry=reTry)
print(f"多对象左键单击: {img}")
else:
mouseClick(clickTimes=1, lOrR='left', img=img, reTry=reTry)
print(f"单对象左键单击: {img}")
i += 1
elif cmdType.value == 2.0: # 左键双击
img = sheet1.row(i)[1].value
reTry = 1
if sheet1.row(i)[2].ctype == 2 and sheet1.row(i)[2].value != 0:
reTry = sheet1.row(i)[2].value
if multi_mode:
mouseClickAll(clickTimes=2, lOrR='left', img=img, reTry=reTry)
print(f"多对象左键双击: {img}")
else:
mouseClick(clickTimes=2, lOrR='left', img=img, reTry=reTry)
print(f"单对象左键双击: {img}")
i += 1
elif cmdType.value == 3.0: # 右键单击
img = sheet1.row(i)[1].value
reTry = 1
if sheet1.row(i)[2].ctype == 2 and sheet1.row(i)[2].value != 0:
reTry = sheet1.row(i)[2].value
if multi_mode:
mouseClickAll(clickTimes=1, lOrR='right', img=img, reTry=reTry)
print(f"多对象右键单击: {img}")
else:
mouseClick(clickTimes=1, lOrR='right', img=img, reTry=reTry)
print(f"单对象右键单击: {img}")
i += 1
# 4代表输入
elif cmdType.value == 4.0:
inputValue = sheet1.row(i)[1].value
pyperclip.copy(inputValue)
pyautogui.hotkey('ctrl', 'v')
print("输入:", inputValue)
time.sleep(0.5)
# 5 代表等待
elif cmdType.value == 5.0:
# 取图片名称
waitTime = sheet1.row(i)[1].value
time.sleep(waitTime)
print("等待", waitTime, "秒")
# 6代表滚轮
elif cmdType.value == 6.0:
# 取图片名称
scroll = sheet1.row(i)[1].value
pyautogui.scroll(int(scroll))
print("滚轮滑动", int(scroll), "距离")
# 7代表_热键组合
elif cmdType.value == 7.0:
# 取重试次数,并循环。
reTry = 1
if sheet1.row(i)[2].ctype == 2 and sheet1.row(i)[2].value != 0:
reTry = sheet1.row(i)[2].value
inputValue = sheet1.row(i)[1].value
hotkeyGroup(reTry, inputValue)
time.sleep(0.5)
# 8代表_粘贴当前时间
elif cmdType.value == 8.0:
# 设置本机当前时间。
localtime = time.strftime("%Y-%m-%d %H：%M：%S", time.localtime())
pyperclip.copy(localtime)
pyautogui.hotkey('ctrl', 'v')
print("粘贴了本机时间:", localtime)
time.sleep(0.5)
# 9代表_系统命令集模式
elif cmdType.value == 9.0:
wincmd = sheet1.row(i)[1].value
os.system(wincmd)
print("运行系统命令:", wincmd)
time.sleep(0.5)
i += 1
# 主程序
while True:
if __name__ == '__main__':
file = 'D:\\BaiduNetdiskDownload\\python自动化_bilibili_V211207\\211207_改良\\cmd.xls'
# 打开文件
wb = xlrd.open_workbook(filename=file)
# 通过索引获取表格sheet页
sheet1 = wb.sheet_by_index(0)
print("欢迎使用自动操作")
# 避免多次循环导致的ctrl+v导入到，按ESC进行取消。
pyautogui.hotkey('esc')
# 数据检查
checkCmd = dataCheck(sheet1)
# 输入选项实现功能
if checkCmd:
key = input(
'选择功能: 1.做一次 2.循环几次 3.循环到死 0.退出程序\n特殊功能：c.清理屏幕显示\n———————————————————————————————————————\n')
if key == '1':
# 循环拿出每一行指令1
print("正在执行第1次命令")
print("")
mainWork(sheet1)
print("")
print("已经完成第1次命令")
print("——————————————————分割线——————————————————")
print("")
elif key == '2':
print("")
count = 0
times = input('输入需要循环的次数，务必输入正整数。\n')
times = int(times)
if count < times:
while count < times:
count += 1
print("正在执行第", count, "次", "命令")
print("")
mainWork(sheet1)
time.sleep(0.1)
print("等待0.1秒")
print("")
print("已经完成第", count, "次", "命令")
print("——————————————————分割线——————————————————")
print("")
else:
print('输入有误或者已经退出!')
os.system('pause')
print("")
print("——————————————————————————————————————————")
elif key == '3':
count = 0
while True:
count += 1
print("正在执行第", count, "次", "命令")
print("")
mainWork(sheet1)
time.sleep(0.1)
print("等待0.1秒")
print("")
print("已经完成第", count, "次", "命令")
print("——————————————————分割线——————————————————")
print("")
elif key == '0':
print("正清理缓存文件...")
os.system('@echo off & for /d %i in (%temp%\^_MEI*) do (rd /s /q "%i")>nul')
exit("正在退出程序...")
elif key == 'c':
os.system('cls')
else:
print('输入有误或者已经退出!')
os.system('pause')
print("")
print("——————————————————————————————————————————")为什么鼠标无法移动
本文介绍了在Windows环境下，如何使用pip安装PyAutoGUI库及其依赖Pillow和OpenCV。在遇到依赖问题时，通过设置pip的国内源来加速并成功安装这些库。此外，还展示了当使用pyautogui.locateCenterOnScreen函数时，为何需要Pillow和OpenCV以及相应的安装方法。
扫一扫
3940
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
