【办公类-25-04】202403012 UIBOT上传 ”周计划“

作品展示:

5db0cbd7c44b4afb94861fd6ab91b750.png

一、背景需求:

本学期制作了 “周计划“第一页横版内容的截图,需要上传园园通

【办公类-22-13】周计划系列(5-5)“周计划-05 上传周计划png“ (2024年调整版本)-CSDN博客文章浏览阅读101次。【办公类-22-13】周计划系列(5-5)“周计划-05 上传周计划png“ (2024年调整版本)https://blog.csdn.net/reasonsummer/article/details/136660866c827507b79804b0c8ad090a890d3fbb1.png

二、制作过程:——批量上传“周计划”

1、工具准备

ec8f18a813174a509a3d3fa3ec731390.png

​​

d60a6202b98f4970b63cf57684b2f0c7.png

​二、代码解析

5aa73dfab5984c54bacbb7c058d40de8.png

ae2016e39402444aad50ce1243b43c78.png

71d2f6e7152a4f088e2168831b337c7b.png

Dim sRet,sName,arrayRet,iRet,标题,bRet,第,temp,),横,时间1,尾,(,杠
Rem 进入教育教学页面 页面90%

Rem 获取所有图片名称
图片名称=File.DirFileOrFolder('''D:\test\02办公类\91周计划4份_2024年中4班\04 周计划\05jpg上传''',"fileandfolder",{"hasPath":true})
TracePrint(图片名称)
长度=Len(图片名称)

// TracePrint(长度)

Rem 提取每个路径的内容
For 份 = 0 To 长度-1 step 1
TracePrint(份)

Mouse.Action(@ui"链接<a>_新建","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Rem 写入图片唯一路径
Mouse.Action(@ui"内联框架<iframe>","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Mouse.Action(@ui"窗口3","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Keyboard.Input(图片名称[份],{"iDelayAfter": 100, "iDelayBefore": 100, "sSimulate": "message"})

Mouse.Action(@ui"窗口_打开(O)","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Delay(1000)
Rem 获取标题的范围(第到))
TracePrint(第)


第=InStr(图片名称[份],"第",1,false)

划=InStr(图片名称[份],"划 ",1,false)
// TracePrint())


(=InStr(图片名称[份],"(2",1,false)

)=InStr(图片名称[份],"日)",1,false)
周次=SubStr(图片名称[份],第,划-第+1)

日期=SubStr(图片名称[份],(,)-(+2)
标题 = 周次+日期
TracePrint(标题)



Rem 获取上传时间的范围((到——)
(=InStr(图片名称[份],'(',1,false)
// TracePrint(()
杠=InStr(图片名称[份],"——",1,false)
// TracePrint(杠)
时间=SubStr(图片名称[份],(+1,杠-(-1)
TracePrint(时间)





Keyboard.InputText(@ui"输入控件<input>_2023-04-3015:35",时间,true,20,10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 500, "bSetForeground": true, "sSimulate": "message", "bValidate": false, "bClickBeforeInput": false})
Keyboard.InputText(@ui"输入控件<input>",标题,true,20,10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 500, "bSetForeground": true, "sSimulate": "message", "bValidate": false, "bClickBeforeInput": false})


Delay(1000)


Mouse.Action(@ui"链接<a>_发布","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Mouse.Action(@ui"按钮<button>_确定","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Delay(10000)



Next

三、第一次结果:

上传后我发现周计划用的日期是“年月日”,而和它在同一栏目里的信息窗是(..)的格式,两者看上去样式不统一。

6561b72886b64a1b8248cb4cf8b85cdc.png

四、删除上传的内容——根据共有的一个关键词删除

因此我需要把刚刚上传的批量删除,重新制作标题文件名再上传周计划。

a408a71f433d4ac7a44a87322c30c526.png

62f8676ba5ca49238b327dac360e918f.png

c4a9ef66b8834f828496ba3543c1dae4.png

五、重新修改日期构成

7aab52d3b9cb4c949c6a4c1836e8647d.png

19271e87b20b4ba1984c9daad7bad325.png

e1da9e8f0c3d46d5ba784bc28f5c24c4.png

Dim sRet,sName,arrayRet,iRet,标题,bRet,第,temp,),横,时间1,尾,(,杠,日1,日2
Rem 进入教育教学页面 页面90%

Rem 获取所有图片名称
图片名称=File.DirFileOrFolder('''D:\test\02办公类\91周计划4份_2024年中4班\04 周计划\05jpg上传''',"fileandfolder",{"hasPath":true})
TracePrint(图片名称)
长度=Len(图片名称)

// TracePrint(长度)

Rem 提取每个路径的内容
For 份 = 0 To 长度-1 step 1
TracePrint(份)

Mouse.Action(@ui"链接<a>_新建","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Rem 写入图片唯一路径
Mouse.Action(@ui"内联框架<iframe>","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Mouse.Action(@ui"窗口3","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Keyboard.Input(图片名称[份],{"iDelayAfter": 100, "iDelayBefore": 100, "sSimulate": "message"})

Mouse.Action(@ui"窗口_打开(O)","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
Delay(1000)
Rem 获取标题的范围(第到))


第=InStr(图片名称[份],"第",1,false)

划=InStr(图片名称[份],"划 ",1,false)
// TracePrint())


(=InStr(图片名称[份],"(2",1,false)

)=InStr(图片名称[份],"日)",1,false)
周次=SubStr(图片名称[份],第,划-第+1)

日0=SubStr(图片名称[份],(,)-(+2)
日1=Replace(日0,"年",".",true)


日2=Replace(日1,"月",".",true)

日期=Replace(日2,"日","",true)
标题 = 周次+日期
TracePrint(标题)



Rem 获取上传时间的范围((到——)
(=InStr(图片名称[份],'(',1,false)
// TracePrint(()
杠=InStr(图片名称[份],"——",1,false)
// TracePrint(杠)
时间=SubStr(图片名称[份],(+1,杠-(-1)
TracePrint(时间)





Keyboard.InputText(@ui"输入控件<input>_2023-04-3015:35",时间,true,20,10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 500, "bSetForeground": true, "sSimulate": "message", "bValidate": false, "bClickBeforeInput": false})
Keyboard.InputText(@ui"输入控件<input>",标题,true,20,10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 500, "bSetForeground": true, "sSimulate": "message", "bValidate": false, "bClickBeforeInput": false})


Delay(1000)


Mouse.Action(@ui"链接<a>_发布","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Mouse.Action(@ui"按钮<button>_确定","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})

Delay(10000)



Next

六、视频运行

感悟:

花了12分半钟上传19张“周计划”,高效快捷,精准。

  • 6
    点赞
  • 9
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

阿夏reasonsummer

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值