How to delete entire row, if row contain value "xyz" in any cell.
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
+15
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.
or
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.