Looking for Excel Activity to lookup a value within Excel Worksheet and get either relative location or row values, all without using the Excel Application Scope
Did you tried with lookup datatable activity
documentation : Lookup Data Table
Videos : How to Lookup Data Table in UiPath - Full tutorial - YouTube
Check this one
Hope it helps you
Regards
Nived N
Happy Automation
Yes, thanks, I ended up going that route. Wish the Lookup Activity worked within the Workbook Activities instead of only being available within the Application Scope. Application Scope seems to always leave an instance of Excel running and ends up causing issues overall.
Having to create a DataTable is a little clunky, but it works. Thanks!