Delete/Remove the row by row the data from Data table dynamically

[SeemaAA (A)]

Hi There,

I should delete the rows one by one dynamically from the excel file - which has only one column…
Ex: I am having a Excel file - have taken it to DT.
Now from DT I am taking the row to one variable.
So I have to Pass this variable to - Remove data row activity…

How shall I pass this
I can see the code for the activity - Remove data row activity… ----“Name=‘TestName2’”
It takes the column name and value inside the column…

So I just want to pass only the value not column name

Regards,
Seema

[skini76]

Can you use DataTable.Rows(x).Delete where x is the row no

[SeemaAA (A)]

But how shall I get the Index??/ row index dynamically

I have to pass this following variable with data

This activity is in For each loop of DT

[SeemaAA (A)]

@skini76
I am not getting it how to do
Have to fix it now …

[skini76]

Delete data row from data table

I am having a excel in format [image] Now I want to delete all the row where Status=“PV”. Please suggest a solution. I want to perform this action using one database table only.

[skini76]

you can try with “remove data row” ie check for condition, if true then remove data row.

[skini76]

You can also try with Invoke code + delete row combination

[trunghai]

Sorry, I have same problem.

Anyone has any solution for this case ?

Thanks in advance!

Highlight or delete cell if not found

I have used Remove Data Row but it has problem. [1] [2]

[skini76]

What is the problem ?

[trunghai]

Hi @skini76

I have list of item want to search on the website. Some item could not found on the web.

I want to highlight or clear row content on excel file with item which not found on the web .

I have made Flow Decision activity to check if item not found, how to use any activity to highlight or clear content of cell on excel file on the left Flow Decision ?

I have tried with some activities but still can not.

Thanks you (11.5 KB)PIC from WEB.zip (11.5 KB)