reading data from excel and doing and Online search

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 $RecordVariable[0], 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.

Zaid Chougle wrote:

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 $RecordVariable[0], 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.