Question

Is there any easy way in A360 to remove rows from Excel Based on some value based conditions

  • 8 February 2022
  • 2 replies
  • 28 views

Is there any easy way in A360 to remove rows from Excel Based on some value based conditions

2 replies

Userlevel 3
Badge +7

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!

 

 

Userlevel 3
Badge +7

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:

 

 

Kind Regards,

Ashwin A.K

Reply