Call Toll Free: 1-888-484-3535    

  Automation Anywhere - The Automation Software

Excel Automation -> T23- Compare two columns in Excel

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.

T23.atmn Compare-Values.xls

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.

Screenshot 1:

Screenshot 2:

Screenshot3:

 

Tags: automated excel, excel automation, excel integration, automate excel, spreadsheet automation

E-Mail: Enter your email address to receive information about new products & offers from Tethys Solutions.


 PRODUCTS

 Automation Anywhere
   Standard & Premier
   Enterprise
 Workspace Macro Pro
 Workspace Macro
 Launch-n-Go
 Free Downloads
 Compare Products
 

 SOLUTIONS FOR

 Home & Home Office
 Business & IT
 Partners
 Developers
 

 SERVICES

 Ask The Expert
 Consulting Service
 

 PURCHASE

 BUY NOW
 Pricing
 Upgrades
 Our Guarantee

 SUPPORT

 FAQ & Examples
 Have a Question?
 Open A Support Case
 Forums
 

 QUICK LINKS

 Productivity Essentials
 Pre-defined Templates
 

 GENERAL

 Tell A Friend, Win a CD
 Affiliates
 Articles: Macro &
 Automation

 Get RSS Feeds

 Press & News
 Contact Us
Home |Site Map |Privacy Policy |About Us |Contact Us

Copyright © 2003-2008 Tethys Solutions, LLC. All rights reserved. Trademarks