RELATED IDEAS
To read large data from excel above upto 2-3 lakh rows
Working with Large data in Blue Prism gives Out of Memory exception even when OLEDB action stage is used, building a VBO which reads large data from excel or anywhere into a collection, will solve many use cases
As an example, please refer to this thread on the Community.
https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=16adfb54-82e0-4699-bf49-d1142daeec53&CommunityKey=1e516cfe-4d1f-4de9-a9eb-58d15bf38c81&bm=16adfb54-82e0-4699-bf49-d1142daeec53#bm16adfb54-82e0-4699-bf49-d1142daeec53
I think this is something that can be handled with existing components and proper process design. As best practices mention, large data sources should be addressed through chunking.