Get Collection from Excel with more then 1500 Rows and 50 Columns

[AndreKöpplin]

Hello Blue Prism Community

We are using Blue Prism v6 in our company and we have an challenge in three of our processes. We noted after the migration from BPv5 to BPv6 and increasing of the assigned work for the Robot, that we have problems to get a bigger excel sheet (1.500 Rows and 50 Columns) into a collection. In BPv6 the system slow down and sometimes blue prism crashed.

Our Developers changed the process flow in this way that the bot went through each cell in the excel file to get the required data for one item in the Workqueue, but this solution took to long for the business. Unfortunately, we are not able to reduce the number of rows or columns in the report.

Have someone of you an advice for me how we can handle this challenge?

Best regards
Andre

------------------------------
Andre Koepplin
Senior Business Process Analyst and Blue Prism Control Room Lead
------------------------------

[david.l.morris · Accepted solution]

You could use the OLEDB VBO called "Data - OLEDB". It allows you to treat Excel like it's a database and query it with SQL queries in order to get the rows in chunks.

https://portal.blueprism.com/documents/standard?title=oledb

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

[AndreKöpplin]

​Hello David

Thanks a lot for this advice.

We found out, that after the migration to Win10/BPv6, we not added this Object to our standard libraries.

Best regards
Andre

------------------------------
Andre Köpplin
Senior Business Process Analyst
------------------------------