Question

How to delete entire row, if row contain value "xyz" in any cell.

  • 3 January 2022
  • 5 replies
  • 53 views

How to delete entire row, if row contain value "xyz" in any cell.

5 replies

Userlevel 5
Badge +9

Hi @Yallaling Bansode​ ,

 

use IF package >> String Condition to check the value is xyz and use Excel advanced: Insert/Delete rows/columns for deletion

Userlevel 5
Badge +9

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

Userlevel 3
Badge +7

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