Delete row from excel

[Rohit_Nandwani]

How to delete an entire row from excel without writing it again after filtering based on some condition?

[Gokul001 (Gokul Balaji)]

Hi @Rohit_Nandwani

Welcome to UiPath community

Have you tried with Delete Row activity

https://docs.uipath.com/activities/docs/delete-rows-x

Have you tried with Insert/ Delete Rows activity

https://docs.uipath.com/activities/docs/excel-insert-delete-rows

Check out the thread

UiPath Tutorial || Day 28 : Insert/Delete Rows

Remove entire row in excel

Hi, How to delete entire row in excel? I have tried write range to replace with new datatable, unfortunately there still old rows in the excel sheet eventhough i put the range as A:Z. [image]

Regards
Gokul

[Rohit_Nandwani]

Using delete row its showing error on position

[Gokul001 (Gokul Balaji)]

Can you share the screenshot of the XAML file with the error @Rohit_Nandwani

[Tapan_Behera1 (Tapan Behera)]

Hi @Rohit_Nandwani use this activity:

[Rohit_Nandwani]

It worked. I was passing the position as 0

[Gokul001 (Gokul Balaji)]

Great @Rohit_Nandwani

Happy automation

Regards
Gokul