Remove row of excel if one cell has "0%" value

Hey Guys

I have one excel file in that data is in tabular format
Now in column sixth , if one cell have " 0.00% " then i have to delete entire row

please tell me how to do this
clearly steps


you can use lookup activity to filter that column, then use the delete row activity, and the use write range activity again to paste that data,


Hi @Shoebmd ,
You can read your excel data using Read Range which outputs a Datatable, then you can use Filter datatable activity and pass the necessary condition .That will generate a filtered datatable and the you can use write range to write it to a new excel sheet


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.