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
burque505
Posts: 1397
Joined: 22 Jan 2017, 19:37

openrpa and AHK via UiPath open-sourced activities

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
openrpa_shrunk.png (123.38 KiB) Viewed 3066 times
pivot_table_shrunk.png
pivot_table_shrunk.png (34.14 KiB) Viewed 3070 times
Attachments
for_forum.zip
(7.54 KiB) Downloaded 99 times
User avatar
tank
Posts: 2851
Joined: 28 Sep 2013, 22:15
Facebook: charlie.simmons.7334
Google: ttnnkkrr
GitHub: ttnnkkrr
Location: Irving TX
Contact:

Re: openrpa and AHK via UiPath open-sourced activities

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;
https://www.facebook.com/ahkscript.org
If you have forum suggestions please submit a pull request
Check Out WebWriter
Thanks Tank :thumbup:
burque505
Posts: 1397
Joined: 22 Jan 2017, 19:37

Re: openrpa and AHK via UiPath open-sourced activities

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.

Return to “RPA”

Who is online

Users browsing this forum: No registered users and 2 guests