Task Description: Automation Anywhere
provides easy Excel Automation. For more information see
Excel
Automation Solution. This examples shows how
to compare two columns in an Excel sheet.
Solution
To see how the task runs in Automation Anywhere,
download the files.
Note: Save the xls in C: drive, the .atmn
file in My Documents -> Automation Anywhere -> Automation
Anywhere -> My Tasks
Below are the steps that make the Task:
1.
Open an Excel sheet
From Application Category->Excel,
Select 'Open Spreadsheet' option
2.
Create Variable
Click on Tools -> Variable Manager.
Create variable Cell1 and Cell2 of type "value".
Screenshot 1
3.
Insert Loop command
Insert loop command for option Times.
Specify the number of rows to compare.
4.
Compare cells
All of the following commands need to be
entered within the Loop
Excel : Get value of Active cell and
assign to variable "Cell1" Screenshot 2
Excel : Go to one cell right of active cell
Excel : Get value of Active cell and assign
to variable "Cell2"
Excel : Go to one cell right of active cell
Compare Cell1 and Cell2 variables and based
on the comparison results perform the required
task.
Go to next row in the Excel document.
Screenshot 3
When you run this task, it compares two Excel
columns.
Automation Anywhere - The Automation Software
