This is from my observation,
Excel data manipulation is most fastest, most reliable, and most versatile through .vbscript and .vbapplication coding, because it let’s you access every Excel feature directly. For example, you can use .Cell() to get cell information and you can use .Find() to quickly move around the spreadsheet. Loops are also faster and can process thousands of lines quicker.
However, the disadvantages to this is that it’s less sustainable and require more knowledge of these script languages. VB is also more difficult to work with websites (but doable), so the consideration would be to use multiple tools that work together, but that in itself adds complication.
With UiPath, you have the ability to work with vb.net query expressions, which let you find and compare information in datatables and arrays instantaneous. This is very reliable and resourceful, however does require knowledge of such methods.
From what I can tell, doing other things in Excel to access features require that you use click or keystroke actions so it’s more indirect. I have been able to make this reliable, though, using the ALT-key combinations that work in Office Applications.
The biggest challenge with UiPath and RPA in general is error handling, because when dealing with element selections on the screen you need to figure out what to do if something happens where the window is different. It takes a while to learn how to do this properly.
So in conclusion,
UiPath gives you the tools to develop what you are wanting, but VBS and VBA will “technically” be more stable (while sacrificing process documentation and sustainability). In my work environment, I have found that UiPath is very useful for Business Process visualization and organization and is reliable enough once the initial challenges of the learning curve have been overcome.
Sorry, if this isn’t the input you were looking for.
If your client is interested in logic similar to the .Find, this can be done in vb.net query within UiPath. The other option would be to create a VBA script in a macro-enabled file, or .vbs script which let’s you double-click to run it and does not rely on the macro file. It’s really up to you and your client, to be honest. It might depend on what you are comfortable with coding or if you need to access Web interfaces then maybe UiPath is the best option.