How to filter a column in an excel sheet based on the value of an another column

excel

#1

I have tried to filter a column in an excel sheet which has the value “Fail” in its corresponding another column, but i am not able to figure out what command i need to give in the assign activity. Can anyone help me out with this??
Thanks in advance :slight_smile:

Main2.xaml (9.1 KB)
Excel.xlsx (9.3 KB)


#2

@im_heathen try below workflow. I have edited your workflow. Change path in excel application scope.

Main2Edited.xaml (9.2 KB)


#3

Bro only the URLs must be written into the sheet not the response and status column too, also it seems to add the columns i want to delete all the data moved in the sheet and write this data into the sheet. how to do that??


#4

@im_heathen i did get you. What output you exactly needed. Please be clear about your output.


#5

Desired O/P

Ex.xlsx (8.4 KB)


#6

@im_heathen try below code. i have edited you code

Main2.xaml (9.2 KB)


#7

Yeah, it works. Thank you :slight_smile: