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

[Gurramkonda]

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 .

[_Amlansahoo]

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

[Mohamad_747]

As @_Amlansahoo  said

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

[SayeedBinAbdullah]

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

[Gurramkonda]

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

[SayeedBinAbdullah]

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

Sayeed Bin Abdullah

[Jrwork]

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

[Jrwork]

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

[SayeedBinAbdullah]

Hi @Gurramkonda ,

Do let us know if your query is resolved?

Best Regards,

Sayeed Bin Abdullah