Search found 13 matches

by gdqb521
12 Mar 2024, 06:21
Forum: Scripts and Functions (v2)
Topic: ImagePut - A core library for images in AutoHotkey (Now supports HEIC & WEBP)
Replies: 82
Views: 29896

Re: ImagePut - A core library for images in AutoHotkey (Now supports HEIC & WEBP)

Hey! I want to take a screenshot and run an imagesearch on it from a Application thats not currently in the foreground/ covered by other applications. how to do used imageput ()? ; 窗口类 ImagePutWindow("ahk_class notepad") Error: Image type could not be identified. ---- d:\LibV2\ImagePut.ah2 565: If C...
by gdqb521
10 Mar 2024, 09:41
Forum: Scripts and Functions (v2)
Topic: UIA v2
Replies: 382
Views: 56887

Re: UIA v2

@Descolada, I test "myDataGrid.Scroll(UIA.ScrollAmount.SmallIncrement)", The error is shown in the figure。 but code "myDataGrid.SetScrollPercent(30)" it works。 When the focus is on the datagrid, pageup or up. Down works, but there are other actions in the middle that cause the focus to be lost. What...
by gdqb521
07 Mar 2024, 22:47
Forum: Scripts and Functions (v2)
Topic: UIA v2
Replies: 382
Views: 56887

Re: UIA v2

@Descolada Thank you for writing the function “MoveMouseToElement(element, offsetX := 0, offsetY := 0, speed?)”,it can work。 Hello, I have 44 DataIetms in a DataGrid, { type: “DataItem” ClassName: “Datagridrow”} , but the screen can only see two DataIetms , UIA can see five, how to make him turn the...
by gdqb521
20 Feb 2024, 19:37
Forum: Scripts and Functions (v2)
Topic: UIA v2
Replies: 382
Views: 56887

Re: UIA v2

How to move the mouse to the object position without clicking, and offsetting the center coordinates a little, the following code always clicks

Code: Select all

WeChatEl := UIA.ElementFromHandle("ahk_exe WeChat.exe")
WeChatEl.ElementFromPath("Y/YL").Click("left","0",,"0 -80")
by gdqb521
28 Feb 2023, 04:42
Forum: 请求帮助
Topic: v1版本批量创建热字符串,使用Hotstring() 求助?
Replies: 0
Views: 629

v1版本批量创建热字符串,使用Hotstring() 求助?

需求:pt9 自动替换为PT20230228009,规则就是字母自动大写,数字转化为日期+3为用0补齐位数的数字组合,例如sk10 替换为:SK20230228010(规则是SK+20230208+010),其中日期按系统日期自动更新。主要问题是字符后面的数字有1~600范围,如何批量创建这个自动替换的字符串? 单个替换能够基本实现: ::pt9:: ::sk10:: thishotkey:=SubStr(A_ThisHotkey,3) ;保存热键到变量 RegExMatch(thishotkey, "i)([a-zA-Z]+)", char) ;正则提取热键中的字母 RegExMatch(t...
by gdqb521
13 Sep 2022, 06:50
Forum: 请求帮助
Topic: 如何让WinHttp.ahk库函数等待请求在网页js运行后,再获取response?
Replies: 2
Views: 1441

Re: 如何让WinHttp.ahk库函数等待请求在网页js运行后,再获取response?

MsgBox , % getSwissTargetJobFromSMILES() getSwissTargetJobFromSMILES(SMILES:="CC1C(=O)CCC2C1(C)CCC1C2(C)CCC2(C)CC(C)(CCC=C(C)C)CCC12C") { HTTP := ComObjCreate("WinHttp.WinHttpRequest.5.1") HTTP.Open("POST", "http://www.swisstargetprediction.ch/predict.php",true) HTTP.SetRequestHeader("User-Agent", ...
by gdqb521
12 Sep 2022, 00:59
Forum: 请求帮助
Topic: 如何让WinHttp.ahk库函数等待请求在网页js运行后,再获取response?
Replies: 2
Views: 1441

如何让WinHttp.ahk库函数等待请求在网页js运行后,再获取response?

通过网站http://www.swisstargetprediction.ch/ 获取数据,但是此函数返回的结果总是提示script错误,推测应该是网页的运算脚本还未来得及运行,就已经返回结果了。 如何能获取正确结果? 返回结果约在152行处附近: location.replace("error_page.php?error=1"); 正确的应该是: location.replace("result.php?job=1123282995&organism=Homo_sapiens"); 其中的job对应的编号就是后面要获取数据的网址的关键词部分。 传入数据为 smiles: CC1C(=O)C...
by gdqb521
29 Aug 2022, 03:45
Forum: 请求帮助
Topic: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved
Replies: 7
Views: 2848

Re: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved

@sikongshan 感谢,这个确实提高的很多,而且用的很巧妙。
虽然我还不能完全理解为什么这样做效率高,但是他确实是目前最高效的实现方式。
再次感谢@kazhafeizhale@sikongshan 的指导。
by gdqb521
25 Aug 2022, 21:05
Forum: 请求帮助
Topic: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved
Replies: 7
Views: 2848

Re: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved

非常感谢 kazhafeizhale ,你的代码效率提高很多。 我将我的完整需求在下面代码中进行的展示,也待优化。 需求是从fulllist中查找关键字,要求在同一个“订单号”项下查找“商品ID”中同时包含kw01和kw02的用户ID等信息,并生成sublist 基于以下代码也能实现,但是和 kazhafeizhale 优化后后面的代码比,效率太低了。能否优化。 kazhafeizhale 的代码,我还在学习中。请赐教! 以下代码实现基于商品ID关键词实现生成sublist,然后在生成out。 商品ID的ini: [kw01] 31710 36711 38711 39711 [kw02] 30...
by gdqb521
25 Aug 2022, 02:13
Forum: 请求帮助
Topic: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved
Replies: 7
Views: 2848

Re: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved

kazhafeizhale wrote:
24 Aug 2022, 23:26
SetBatchLines, -1
脚本加这个会加速
测试确实提高了速度,时间缩短了一半。
还有没有更高效的办法,主要是正式数据差不多是现在的10~100倍,然后处理一次都是几个小时,实际需求需要很多次处理。所以时间要求较高。
by gdqb521
24 Aug 2022, 19:22
Forum: Ask for Help (v1)
Topic: How to improve the efficiency of querying the general table based on sublists?
Replies: 2
Views: 480

How to improve the efficiency of querying the general table based on sublists?

Description of the problem: There are 3 fields and 63 rows in the subtable. To find the row data in the total table (10 fields and 100002 rows) that contains three fields of the subtable, and copy it to a new document. The three fields of the subtable correspond to the 2nd, 6th, and 7th fields of th...
by gdqb521
24 Aug 2022, 10:13
Forum: 请求帮助
Topic: 如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved
Replies: 7
Views: 2848

如何基于多个字段的子列表查询总表中的数据,并复制到新表? Topic is solved

问题描述:子表中有3个字段,63行,要将总表(10个字段100002行)中同时包含子表三个字段的行数据找到,并复制到新的文档。 子表的三个字段分别对应总表的第2、6、7字段。 主要问题在如何提高查找的效率?我电脑上基于示例数据,用遍历循环筛选完要5秒钟左右,当数据增加时,筛选时间也呈几何倍数增长,是否有更高效的处理方式? 筛选完的行数有1027行。 示例数据: 示例.zip T_start:=A_TickCount fulllist:=A_ScriptDir "\fulllist.csv" sublist:=A_ScriptDir "\sublist.csv" SplitPath, full...
by gdqb521
15 Aug 2015, 10:17
Forum: 请求帮助
Topic: 通过shell.Application返回IE的Window对象,无法获取网页中元素,请高手指点?多谢了
Replies: 3
Views: 3585

Re: 通过shell.Application返回IE的Window对象,无法获取网页中元素,请高手指点?多谢了

柳暗花明又一村啊,我近期就在找这个,回头测试,我用win10好像兼容不是太好。

Go to advanced search