Lookup Value in Excel without using Excel Application Scope

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

Hi @Scott_Taylor

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


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!