<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic We have seen issues with this in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52702#M7535</link>
    <description>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.</description>
    <pubDate>Tue, 28 Nov 2017 07:49:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2017-11-28T07:49:00Z</dc:date>
    <item>
      <title>MS Excel VBO - Get Worksheet as collection no rows</title>
      <link>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52700#M7533</link>
      <description>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.</description>
      <pubDate>Tue, 21 Nov 2017 15:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52700#M7533</guid>
      <dc:creator>IsmaelRamirez</dc:creator>
      <dc:date>2017-11-21T15:46:00Z</dc:date>
    </item>
    <item>
      <title>Hi,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52701#M7534</link>
      <description>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.</description>
      <pubDate>Tue, 21 Nov 2017 17:07:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52701#M7534</guid>
      <dc:creator>AnatoliyBanniko</dc:creator>
      <dc:date>2017-11-21T17:07:00Z</dc:date>
    </item>
    <item>
      <title>We have seen issues with this</title>
      <link>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52702#M7535</link>
      <description>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.</description>
      <pubDate>Tue, 28 Nov 2017 07:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO-Get-Worksheet-as-collection-no-rows/m-p/52702#M7535</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-11-28T07:49:00Z</dc:date>
    </item>
  </channel>
</rss>

