a week ago
After migrating from BP 6.9v to 7.2v, we found that a new input was added in the MS Excel VBO for the 'Get Worksheet as Collection' action. It now includes a 'Fetch Data with Method' option. We used the 'Text' method, but it is taking significantly more time to load data into the collection compared to version 6.9, which was faster at retrieving data. Please advise do you have other alternate option .
a week ago
Download the latest version of the VBO from DX. It has the old code which you need.
a week ago
As @_Amlansahoo said
You can use this link: https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo
a week ago
Hi @Gurramkonda
Please could you let me know what is the size of excel/number of rows and columns in the excel?
Best Regards,
Sayeed Bin Abdullah
a week ago
The size of excel sheet is 40,000 rows and 9 columns
a week ago - last edited a week ago
Once you have data in the collection what activity you will be performing on the data?
Sayeed Bin Abdullah
a week ago - last edited a week ago
E aí amigo!
Não é possível usar via OLEDB?
a week ago
Oi @Gurramkonda Asking a question, but I didn't give guidance to follow, here are the DX links for you to use OLEDB:
https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---oledb
For CSV files:
https://digitalexchange.blueprism.com/dx/entry/3439/solution/blue-prism---read-csv
For multiple connections: (very interesting)
https://digitalexchange.blueprism.com/dx/entry/127021/solution/manish-konathala
If you have questions about the first link, I can upload my connection release here and then you can just change your parameters, but this way, it's a simple configuration.
Bro, if you have anything, comment on the post and I'm at your complete disposal, a hug and have a good week! 🤝
Thursday - last edited Thursday
Hi @Gurramkonda ,
Do let us know if your query is resolved?
Best Regards,
Sayeed Bin Abdullah