29-09-18 02:14 AM
29-09-18 11:34 PM
17-01-23 10:06 PM
18-01-23 06:16 AM
Hi Ben,
The 'rewrite' is not so much a programming effort as it is deploying the BP OLEDB object rather than another BP VBO to extract data from an XL. The OLEDB object can be used to SQL against an XL file and get its contents to a Collection. As it does use a better/more speedy method, it uses less memory which can be a life saver for large XLs. Search the community for OLEDB and you should find many postings on this subject.
Example:
https://community.blueprism.com/communities/community-home/digestviewer/view-question?ContributedContentKey=f5603485-f4b5-4db8-99d6-f87551a0978a&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01#15210...
18-01-23 03:34 PM
23-01-23 09:59 AM
23-01-23 10:00 AM