Hi, Could any one help use Loop record variable that has excel row value to do online search using automation anywhere tool
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.