MS Excel VBO - Get Worksheet as collection no rows

[IsmaelRamirez]

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.

[AnatoliyBanniko]

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]

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.