topic Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V in Product Forum

MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

Gurramkonda — Thu, 23 Jan 2025 09:45:17 GMT

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 .

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

_Amlansahoo — Thu, 23 Jan 2025 19:05:34 GMT

Download the latest version of the VBO from DX. It has the old code which you need.

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

Mohamad_Dakkouri — Thu, 23 Jan 2025 21:41:13 GMT

As @_Amlansahoo said

You can use this link: https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

SayeedBinAbdullah — Fri, 24 Jan 2025 13:52:25 GMT

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

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

Gurramkonda — Fri, 24 Jan 2025 14:03:48 GMT

The size of excel sheet is 40,000 rows and 9 columns

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

SayeedBinAbdullah — Fri, 24 Jan 2025 14:15:14 GMT

Once you have data in the collection what activity you will be performing on the data?

Sayeed Bin Abdullah

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

Jrwork — Fri, 24 Jan 2025 21:29:39 GMT

E aí amigo!
Não é possível usar via OLEDB?

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

Jrwork — Sat, 25 Jan 2025 12:36:50 GMT

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! 🤝

Re: MS Excel VBO for the 'Get Worksheet as Collection' action performance slow in 7.2 V

SayeedBinAbdullah — Thu, 30 Jan 2025 15:30:46 GMT

Hi @Gurramkonda ,

Do let us know if your query is resolved?

Best Regards,

Sayeed Bin Abdullah