topic RE: Ms Excel VBO - Get Worksheet as Collection(Fast) is limiting the number of rows. in Product Forum

Ms Excel VBO - Get Worksheet as Collection(Fast) is limiting the number of rows.

NakulDange — Thu, 02 Dec 2021 13:24:00 GMT

Hi,
I am Using MS Excel VBO's Get Worksheet as Collection(Fast) action to read a csv file which has 2600 rows but action is reading only 1829 rows.
I have not faced this weird issue before this. I tried with .xls and .xlsx file same results.
Can some help here?

------------------------------
Nakul Dange
------------------------------

RE: Ms Excel VBO - Get Worksheet as Collection(Fast) is limiting the number of rows.

PvD_SE — Thu, 02 Dec 2021 13:53:00 GMT

Haven't tried the 'fast' one but the normal 'Get Worksheet as Collection' certainly works with thousands of rows.

Some questions:

How many columns do you have?
Is there anything particular that looks odd on rows 1829 or 1830?

------------------------------
Happy coding!
Paul
Sweden
------------------------------

RE: Ms Excel VBO - Get Worksheet as Collection(Fast) is limiting the number of rows.

ewilson — Thu, 02 Dec 2021 18:46:00 GMT

Hi @Nakul Dange,

What version of Blue Prism are you using? In the current VBO, available on the DX, the Get Worksheet as Collection (Fast) action has been deprecated. In fact, it's been deprecated for some time now. There's still an action with that name in the VBO, but if you look at its definition all it does is call the regular Get Worksheet as Collection action with all the input items defaulted.

Do you experience the same behavior if you call the the regular Get Worksheet as Collection action?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------