How can we remove the rows?

[Swam_Pitla]

Hi Everyone,

I want to delete rows which is having “-” this special character in excel.how can i do that.
can anyone tell me.
the excel is looks like below image

Thanks in advance
Swamy

[sudhasagar (sagar)]

@Swam_Pitla Use Regex Expression

[monika.c (Monika Chaudhari)]

you can use filter datatable activity…

[Swam_Pitla]

Hi @monika.c Thanks for ur response

I have already tried Filter Datatable there is Headers on top of that.is it possible to give column number or cell id instead of Column Name.

[monika.c (Monika Chaudhari)]

1.Use assign activity…
RowsCount=dt.Rows.Count.Tostring

2.Then use read range activity…and pass range as…A4:RowsCount

3After that use filter datatable activity…and pass your column name.

[sarathi125 (Parthasarathi)]

@Swam_Pitla,

Check with this xaml, place the xlsx file in your desktop and run the xaml.
I have done it using Excel.Extension package, which is a UiPath Team Package.

DeleteRowInExcel.xaml (10.2 KB) Trans.xlsx (10.1 KB)