Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

NakulDange
Level 2

‎02-12-21 01:24 PM

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
------------------------------
0 Likes
2 REPLIES 2

PvD_SE
Level 12

‎02-12-21 01:53 PM

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
------------------------------
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)
0 Likes

ewilson
Staff
Staff

‎02-12-21 06:46 PM

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