Error encountered on deleting entire row in an excel sheet

[MaeHU]

I wanted to delete a row based on a condition of a column cell value if empty. This activity is running on a For Each Excel Row and If-else condition. I used the Delete Rows activity and got this error.

I have tried the solution here and still fails

Deleting an entire row in an excel sheet based on a cell value of column

Hi i am trying to delete the entire row in the excel sheet is the cell in a particular column is empty ,. [chk] So like in the above screenshot i am looking in column Q and if any cell is empty it will delete the entire row from the sheet so far i have [row] tried taking each excel row and putting the condition for empty but it is not working

When I tried using the filter method

Any thoughts?

Thanks!

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

May I know how did you enter your input for delete rows activity. If you provide screenshot that would be better for troubleshooting the issue. Thanks.

[MaeHU]

This is when I tried to delete a current row using If-Else and

[MaeHU]

And this one is using the filter method, as an alternative

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

In studiox delete rows activity you cannot use directly currentrow it will not accept. Intead you can have currentindex so that it will delete the current row. Please try and let me know. Thanks.

[MaeHU]

Thank you Mahanthi!

CurrentIndex did the trick. It is currently deleting the row.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Your most welcome. Could you pls mark my response as solution so that it would help others who are facing the same issue. Thanks.

[WICAKSONO_Hanif]

would you tell me how? i have the same error