Hi @Mahesh S​ ,

You can remove the excel row using the below options,

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-delete-action-rows-columns.html/p>

Include the If conditions after that add the delete row action to remove the required row.

Note : For deleting the rows, you have to get the cell while looping the excel file

Thanks!

Hi @Mahesh S​ ,

If the dataset is large, I would recommend connecting to Excel like it were a Database and use SQL queries to Filter out the data you want.

Here are few links to help you out with that:

• Quicktips: AAIllustrates
• Introduction to Concept
• Advanced Concepts

Kind Regards,

Ashwin A.K