Darshan Hiranandani : How can I use Blue Prism to delete rows in Excel based on another Excel file?

[darshanhiranandani23]

Hi team,

I’m looking to use Blue Prism to delete rows in an Excel file based on criteria from another Excel file. If anyone has experience with this or any tips on how to set this up, I’d really appreciate your input.

Specifically, I’m interested in:

• Steps to configure Blue Prism for this task.
• Any useful Blue Prism actions or objects to use.
• Common pitfalls and how to avoid them.

Regards

Darshan Hiranandani

[harish.mogulluri]

Hello darshan,

Instead of directly deleting the rows in the second excel. probably you can try reading the data  from excel 1as coll1 and read the data from excel 2 as coll2 and based on the condition in coll1 filter the collection in collection2 and  the filtered response  you can create new excel file and copy the filtered data to excel

There are lot of different way you can do it like you can extend the ms excel VBO and perform some of the actions or filters in the excel itself

Based on the approach you might need to use additional vbo or extend the existing utilities and some of th utilities you can use :

1) MS excel VBO
2) Utility collection - Manipulation

Once you are satisfied with the approach and test thoroughly and try negative cases based on different tdata will help you to  identify any code related issues.