I’m preparing a POC for my first automation proyect with UIYPath, a process in which 90% is formatting, filtering, inserting and removing rows in Excel. I’ve tried doing it using 2 approaches:
- UIPath activities + Invoke VBA for the Excel specific operations.
- UIPath activities against Data Tables.
I’ve realized that the 2nd approach is 6-7 times slower, so I think the 1st one is the best option if you pursue performance. But what about best practices? Is there any recommendation against the massive use of VBA vs. processing Data Tables?
I’m considering using the 1st approach for the final development, even doing the whole Excel processing using VBA and in UIPath only invoke it, but I want to know that I’m not breaking any best practice rule.