按键精灵逐条复制EXCEL到另一个程序上 20
我需要把EXCEL表一列中的数据复制到另一程序上,而另一程序先删除,再粘贴,但是数据总是读不出来,麻烦给看看,哪里出现问题CallPlugin.Office.OpenXl...
我需要把EXCEL表一列中的数据复制到另一程序上,而另一程序先删除,再粘贴,但是数据总是读不出来,麻烦给看看,哪里出现问题
Call Plugin.Office.OpenXls("C:\Users\hgjghj\Desktop\测试1.xls")//具体Excel文件路径自行修改
Delay 1000
i = 2
For i = 2 to 10//运行次数按自己要求改
Text = Plugin.Office.ReadXls(1, i, 1)
Delay 100
Call Plugin.Window.Active(269258)
Delay 1000
Call Plugin.Window.Max(269258)
Delay 1000
MoveTo 294, 536
LeftDown 1
MoveTo 163, 536
Delay 485
LeftUp 1
Delay 1000
KeyDown "BackSpace", 1
Delay 100
KeyUp "BackSpace", 1
Delay 100
SayString Text
Delay 1000
Call Plugin.Office.CloseXls()
Delay 100
i = i + 1
Next 展开
Call Plugin.Office.OpenXls("C:\Users\hgjghj\Desktop\测试1.xls")//具体Excel文件路径自行修改
Delay 1000
i = 2
For i = 2 to 10//运行次数按自己要求改
Text = Plugin.Office.ReadXls(1, i, 1)
Delay 100
Call Plugin.Window.Active(269258)
Delay 1000
Call Plugin.Window.Max(269258)
Delay 1000
MoveTo 294, 536
LeftDown 1
MoveTo 163, 536
Delay 485
LeftUp 1
Delay 1000
KeyDown "BackSpace", 1
Delay 100
KeyUp "BackSpace", 1
Delay 100
SayString Text
Delay 1000
Call Plugin.Office.CloseXls()
Delay 100
i = i + 1
Next 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询