How to Delete Entire Excel row without using Excel Application Scope

Hello,

I am trying to delete Second Row from excel without using Excel Application Scope.
Can anyone please suggest the solution.

I have put the condition if A2 & A3 cell value is same then delete A3 row, So condition is working but Deletion not happened.

Want to delete A3 Entire Row
image

You may be able to convert the data into a datatable, use the remove duplicates datatable acitivty and re-populate into the spreadsheet. However, it is most efficient when using the excel application scope.

2 Likes

The EAS Way:
grafik

also have a look at this activity:
grafik

Hi @nilesh.mahajan
Use Invoke code activity , and create argument for datatable

enter the below syntax inside the invoke code activity

In_Datatable.Rows.Remove("row index you want to remove")

Where In_Datatable is the argument for your input datatable

Hope it solves your issue

Thanks
Robin

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