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 : https://docs.uipath.com/activities/docs/lookup-data-table
Videos : https://youtu.be/IffS8VXFilc
Check this one
Hope it helps you
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!