https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89178#M39612 ​Hello David<BR /><BR />Thanks a lot for this advice.<BR /><BR />We found out, that after the migration to Win10/BPv6, we not added this Object to our standard libraries. <BR /><BR />Best regards<BR />Andre<BR /><BR />------------------------------<BR />Andre Köpplin<BR />Senior Business Process Analyst<BR />------------------------------<BR /> Tue, 23 Jul 2019 11:00:00 GMT AndreKöpplin 2019-07-23T11:00:00Z https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89176#M39610 <P>Hello Blue Prism Community<BR /><BR />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.<BR /><BR />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.<BR /><BR />Have someone of you an advice for me how we can handle this challenge?<BR /><BR />Best regards<BR />Andre</P><BR /><BR />------------------------------<BR />Andre Koepplin<BR />Senior Business Process Analyst and Blue Prism Control Room Lead<BR />------------------------------<BR /> Tue, 25 Jun 2019 13:36:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89176#M39610 AndreKöpplin 2019-06-25T13:36:00Z https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89177#M39611 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.<BR /><BR /><A href="https://portal.blueprism.com/documents/standard?title=oledb" target="test_blank">https://portal.blueprism.com/documents/standard?title=oledb</A><BR /><BR />------------------------------<BR />Dave Morris<BR />3Ci @ Southern Company<BR />Atlanta, GA<BR />------------------------------<BR /> Tue, 25 Jun 2019 14:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89177#M39611 david.l.morris 2019-06-25T14:00:00Z https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89178#M39612 ​Hello David<BR /><BR />Thanks a lot for this advice.<BR /><BR />We found out, that after the migration to Win10/BPv6, we not added this Object to our standard libraries. <BR /><BR />Best regards<BR />Andre<BR /><BR />------------------------------<BR />Andre Köpplin<BR />Senior Business Process Analyst<BR />------------------------------<BR /> Tue, 23 Jul 2019 11:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-with-more-then-1500-Rows-and-50/m-p/89178#M39612 AndreKöpplin 2019-07-23T11:00:00Z