Hi @Yallaling Bansode ,
use IF package >> String Condition to check the value is xyz and use Excel advanced: Insert/Delete rows/columns for deletion
Hi @Yallaling Bansode
Use IF package >> String Condition with Includes Operator for Checking the string contain xyz
example row 1= abc | 123 | xyz
row2= bcd | 345 | ffd
row3 = abc|344 | xyz
i want to delete row1 and row3
You can import it into the Data Table. after that loop the data table to identify the "XYZ" with a Row index value. once you get the Row index use Data Table: Delete row action to remove the entire row after that you can write as excel.
You can also delete the row directly from the excel sheet using Keystrokes
How to identify "XYZ" with a Row index value. Please can you explain step by step.
I am new to automation anywhere
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.