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














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