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

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