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:
||Create new task
||Click on New->Task Editor.
||Open Excel file
||From Application Category->Excel,
Select 'Open Spreadsheet' option
||Click on Tools -> Variable Manager.
Create variable Cell1 of type "value".
||Loop through all the
rows until the word 'STOP' is found
Insert Loop for variable "Cell1" not equal to
Insert If command to compare value of variable
to specified criteria (For this task specified criteria
||Delete the row if the
If Criteria matches delete the entire row.
Excel: Delete Active Cell with option entire
Insert the Close Spreadsheet command.
Uncheck the 'Do not save the changes' checkbox
to save changes.
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.