Filter data and delete

Hi Team,

How to filter specific column with N/A value and delete it.Pls guide the solution so I will try

DT.Asenumerable.Where(Function(r) Not r(Col_NameOrIndex).Tostring.Trim.Equals(“N/A”)).Copytodatatable

You shouldn’t be UI Automating in Excel.

You use Excel activities to read the data into a datatable (ie Read Range, etc) and then manipulate the data in the datatable (ie Filter Datatable). Then you write back to Excel (ie Write Range etc).