| 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') |
| 6. | Delete the row if the criteria matches |
If Criteria matches delete the entire row
Excel: Delete Active Cell with option entire row Screenshot 3 |
| |
| 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. |