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

darshanhiranandani23 — Mon, 02 Sep 2024 05:22:49 GMT

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

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

harish.mogulluri — Mon, 02 Sep 2024 22:28:29 GMT

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.

topic Re: Darshan Hiranandani : How can I use Blue Prism to delete rows in Excel based on another Excel fi in Product Forum

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

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