Skip to main content

Hi, Could any one help use Loop record variable that has excel row value to do online search using automation anywhere tool

Hey @manognya.prasad ,

  • 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 @manognya.prasad ,

  • 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