openrpa and AHK via UiPath open-sourced activities

Discuss Robotics Process Automation. RPA is a rapidly growing field with 6 figure incomes and an extreme workforce shortage. This sub forum will be used to discuss aspects of RPA as it relates to both scripting languages and RPA software such as UIPath or Automation Anywhere
Post Reply
Posts: 1446
Joined: 22 Jan 2017, 19:37

openrpa and AHK via UiPath open-sourced activities

Post by burque505 » 21 Jul 2019, 13:32

Take a look here for info on openrpa. Still in alpha but fast and powerful, and attracting worldwide interest.
Amazingly, UiPath's open-sourced Script Activities (basically AutoHotkey and Powerpoint for my purposes), drop in and just work. (I have had to add a new function to AutoHotkey.Interop (wrapper around AutoHotkey.dll's ahkReady() function, which is missing from the AutoHotkey.Interop package on github. I recompiled the UiPath Community Activities to include it, so I could drop in the new dll.)
Just a couple of teasers - this is AHK using EPPlus creating a COM object inside openrpa to make Excel create a pivot table. The script will probably look really strange with its function and SetTimer calls. These are needed to avoid asynchronous call problems here (and UiPath for that matter). You can either run an AHK script or access functions from one, which is what I did here. Many thanks to @LuisSalas for his CommentBox() script, I really like it and I used it here. The AHK script and the Excel file I used should be in the ZIP archive.

EDIT: EPPlus not required. Straight COM object creation to run Excel.

openrpa_shrunk.png (123.38 KiB) Viewed 3119 times
pivot_table_shrunk.png (34.14 KiB) Viewed 3123 times
(7.54 KiB) Downloaded 102 times
User avatar
Posts: 2855
Joined: 28 Sep 2013, 22:15
Facebook: charlie.simmons.7334
Google: ttnnkkrr
GitHub: ttnnkkrr
Location: Irving TX

Re: openrpa and AHK via UiPath open-sourced activities

Post by tank » 22 Jul 2019, 08:32

Wow thank you
It still amazes me that this industry has more akin to the wild west than anything. There isnt even a standard definition for a bot or a common theme to license models. These free RPA solutions that pop up are really disruptive to the big boy's lease on control
We are troubled on every side‚ yet not distressed; we are perplexed‚
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;
If you have forum suggestions please submit a pull request
Check Out WebWriter
Thanks Tank :thumbup:
Posts: 1446
Joined: 22 Jan 2017, 19:37

Re: openrpa and AHK via UiPath open-sourced activities

Post by burque505 » 22 Jul 2019, 09:35

I'm willing to bet the Python-based solutions like Automagica, pybotlib, TagUI Python, and so on are going to start making inroads also.
Post Reply

Return to “RPA”