Automation Software
Call Toll Free: 1-888-484-3535   

automation software  Automation Anywhere - The Automation Software

Excel Automation -> T32 - Delete rows from Excel document based on specific criteria

Task Description: Automation Anywhere provides easy Excel Automation. For more information see Excel Automation Solution. This examples shows how to delete rows from an Excel sheet if the cell contains a specific word.

Solution

To see how the task runs in Automation Anywhere, download the files.

T32.atmn Delete-Rows.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. Create new task Click on New->Task Editor.
2. Open Excel file From Application Category->Excel, Select 'Open Spreadsheet' option Screenshot 1.
3. Create Variable Click on Tools -> Variable Manager. Create variable Cell1 of type "value".
4. Loop through all the rows until the word 'STOP' is found

Insert Loop for variable "Cell1" not equal to "STOP". Screenshot 2

5. IF Command

Insert If command to compare value of variable to specified criteria (For this task specified criteria is 'automation')
Screenshot 3

6. Delete the row if the criteria matches

If Criteria matches delete the entire row.

Excel: Delete Active Cell with option entire row.

7. Close Spreadsheet

Insert the Close Spreadsheet command.

Uncheck the 'Do not save the changes' checkbox to save changes. Screenshot 4

 
When you run this task, it loops through all the cells in the first column in excel sheet until word 'STOP' is found. If it matches criteria given by user then it will delete that particular row from excel sheet.

Note: You can run this task on any column. Simply keep the cell in that column selected before you run the task.

Screenshot 1:

Excel Automation

Screenshot 2:

Variable Manager

Screenshot 3:

Automate Tasks

Screenshot 4:

Automate Excel

 

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 Automation Anywhere.


 PRODUCTS

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

 SERVICES

 Ask The Expert

 PURCHASE

 BUY NOW
 Pricing
 Upgrades
 Our Guarantee

 CUSTOMERS

 Customer List
 Case Studies
 Testimonies

 SUPPORT

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

 QUICK LINKS

 Productivity Essentials

 GENERAL

 Partners
 Affiliates
 Articles: Macro &
 Automation

 Press & News

 Contact Us
 
Home |Site Map |Privacy Policy |About Us |Contact Us

Copyright 2014. Automation Anywhere, Inc. previously known as Tethys Solutions, LLC. All rights reserved. Trademarks