Hi, Could any one help use Loop record variable that has excel row value to do online search using automation anywhere tool
reading data from excel and doing and Online search
Page 1 / 1
Hey
- Open the excel you want to read using Excel Advanced → Open and set an appropriate session name.
- Using Loop → For each row in Excel Advanced → Assign Record variable.
- Use $RecordVariabled0], to access the data from first position of the current row$
Refer below screenshot for your reference.
Hello,
Step 1: Open excel.
Step 2: Get the sheet data in a table variable using get multiple cell action.
Step 3: Use loop action, and loop through the table variable.
Step 4: In loop action assign the value to the record variable.
Step 5: Inside the loop action pass the records variable with the respective required index.
Thanks
Happy Automation.
Hey
- Open the excel you want to read using Excel Advanced → Open and set an appropriate session name.
- Using Loop → For each row in Excel Advanced → Assign Record variable.
- Use $RecordVariabler0], to access the data from first position of the current row$
Refer below screenshot for your reference.
Or Column name if the Excel sheet has headers.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.