Articles → AUTOMATION ANYWHERE → Loop Through All The Rows In Excel In Automation Anywhere 10.5

Loop Through All The Rows In Excel In Automation Anywhere 10.5





  1. Open excel
  2. Get data from all cells.
  3. Loop through excel dataset
  4. Close excel

Excel File




Picture showing the sample excel file
Click to Enlarge


Add Commands




Picture showing the pop up of open spreadsheet command
Click to Enlarge





Picture showing the pop up of Get Cells command
Click to Enlarge





Picture showing the pop up of Each row in excel dataset command
Click to Enlarge



Picture showing the message box activity to show the concatenated values of the column
Click to Enlarge



Picture showing the code of all the commands for reading the excel
Click to Enlarge



Picture showing the output of Loop through all the rows in excel in automation anywhere
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, September 25, 2018

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250