Excel, deleting specific rows containing specific value

Help StudioX
,
1

Hi,

Do you have any tips of how do I set studio X so it deletes rows that contain certain values, for example:

This is what I have now:
ss1

And I would want it to delete rows that contain words: Bus, and Car so the expected result would be:

ss2

2

Hi @marcin.chowaniec

Remove_Certain _Row.xaml (9.5 KB)
I have attached a sample workflow. Hopefully, you’ll find this useful.

1 Like
3

Hi, I’m using studio x

4

Crete list variable to store the input words.
listOfString = new List(Of String) From {“Bus”,“Car”}
Using assign activity and filter the unwanted rows.
dt_input = dt_input.AsEnumerable.Where(function(x) Not
listOfString.Contains(x(“Transport”).ToString)).CopyToDataTable

5

HI @marcin.chowaniec

You can use Filter Datatable activity

Read range and store then in a datatable
use Filter datatable and make the filter wizard like this

image
image1089Ă—409 27.4 KB

image
image1185Ă—477 29.6 KB

Now the filtered datatable will only have the aeroplane row you can write them on the excel file

1 Like