Closed
trying to extract a row from excel, As provided in the images I would give the ID of the person in the first window form and my automation has to retrieve the row pertaining to that ID. I have attached my automation as well can some one help me where it's
***Moderator Edit: Vidyaranjan | Updated Categories***
Posted: 7 years ago
TATA Consultancy Services
TATA Consultancy Services
US
Replace your automation with the below, it should work. Also any link coming out of the form should be asynchronous.
Posted: 7 years ago
Binghamton University State University of New York
Binghamton University State University of New York
US
Thank You so much for your timely help, it worked. Do you know any way I can export the excel sheet without providing the end cell (keeping it dynamic), because I would always not know how huge my excel spreadsheet would be everytime I run my automation.
Posted: 7 years ago
TATA Consultancy Services
TATA Consultancy Services
US
Hi Dedeepya,
Jeff Badger had written up a nice article on how to work with Excel(link to that: excel-how to). Please use that as it answers most of your queries/concerns.
But for the sake of time, please find the automation specific to your ask. Please find the automation file(PR_LoadExcelToLookUp.os.txt) also attached.
