cancel
Showing results for 
Search instead for 
Did you mean: 

MS Excel VBO - Get Worksheet as collection no rows

IsmaelRamirez
Level 3
Hi, Is anyone having issues when using the action get worksheet as collection? Our problem is that sometimes it is not getting any data into the collection which means 0 rows when it's not true. Is not throwing any kind of error and if I retry the action then it will work. This is happening very randomly and the frequency of this issue is very variable as well, definitely not every day, and with totally different processes/excel files. Any thoughts about this? BP Version 5.0.12.0.
2 REPLIES 2

AnatoliyBanniko
Level 4
Hi, I have had same issue when reading a worksheet into a collection with predefined fields. Two fields(columns) that were empty after get as coll action were associated with data type number and datetime. I have basically changed my input collection fields to all TEXT data type and after that all fields were read successfully. I dont know if it is your case but it may help.

Anonymous
Not applicable
We have seen issues with this object. The error that we get is something like ""unable to locate parameter - s"". There's no error handling in the code stage from what I can see.