18-01-21 04:55 PM
Answered! Go to Answer.
19-01-21 11:26 AM
19-01-21 11:26 AM
19-01-21 09:30 PM
Hello, Samuel,
short answer - Blue Prism is 32 bit! Regardless of the installer it is running as 32 bit application therefore when reading many rows from excel into collection you are hitting the limit. When I say many rows I ran around 50.000 it worked as it also depends on the number of columns. If you can avoid loading the whole worksheet in the collection and rather loading just some filter subset that could help you. Or the best approach would be to use ODBC access to your excel. That supports both writing and reading.
Regards,