<?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 Loda data from Excel worksheet tab into a Collection results in an error. in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Loda-data-from-Excel-worksheet-tab-into-a-Collection-results-in/m-p/63088#M16084</link>
    <description>We are loading data from an Excel worksheet tab into a Collection, using a copy of the MS Excel VBO object.&amp;nbsp; (We have added an&amp;nbsp;action or two to the base VBO, but we have NOT modified any base code provided by BP.)&amp;nbsp; We are using the "Get Worksheet As Collection" action.&amp;nbsp; We get an error in the session log upon executing the action: "ERROR: Internal: Could not execute code stage because exception thrown by code stage: Value cannot be null.&amp;nbsp; Parameter name: s" in the session log when we run the action.&amp;nbsp; There are 3 input parameters and 2 output parameters associated with this action.&amp;nbsp; Of these, only 1 begins with an "s": sheetexists.&amp;nbsp; Please refer to the attached screenshots.&amp;nbsp;

What is the cause of this error, and how can we fix it?&amp;nbsp;

Thanks for your help.

&amp;nbsp;</description>
    <pubDate>Wed, 11 Apr 2018 02:42:00 GMT</pubDate>
    <dc:creator>PeterLomi</dc:creator>
    <dc:date>2018-04-11T02:42:00Z</dc:date>
    <item>
      <title>Loda data from Excel worksheet tab into a Collection results in an error.</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Loda-data-from-Excel-worksheet-tab-into-a-Collection-results-in/m-p/63088#M16084</link>
      <description>We are loading data from an Excel worksheet tab into a Collection, using a copy of the MS Excel VBO object.&amp;nbsp; (We have added an&amp;nbsp;action or two to the base VBO, but we have NOT modified any base code provided by BP.)&amp;nbsp; We are using the "Get Worksheet As Collection" action.&amp;nbsp; We get an error in the session log upon executing the action: "ERROR: Internal: Could not execute code stage because exception thrown by code stage: Value cannot be null.&amp;nbsp; Parameter name: s" in the session log when we run the action.&amp;nbsp; There are 3 input parameters and 2 output parameters associated with this action.&amp;nbsp; Of these, only 1 begins with an "s": sheetexists.&amp;nbsp; Please refer to the attached screenshots.&amp;nbsp;

What is the cause of this error, and how can we fix it?&amp;nbsp;

Thanks for your help.

&amp;nbsp;</description>
      <pubDate>Wed, 11 Apr 2018 02:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Loda-data-from-Excel-worksheet-tab-into-a-Collection-results-in/m-p/63088#M16084</guid>
      <dc:creator>PeterLomi</dc:creator>
      <dc:date>2018-04-11T02:42:00Z</dc:date>
    </item>
    <item>
      <title>I would look closely at the…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Loda-data-from-Excel-worksheet-tab-into-a-Collection-results-in/m-p/63089#M16085</link>
      <description>I would look closely at the worksheet you are importing because there is something wrong with the format of it.&amp;nbsp; I.e. are there blank column headers in the range you are loading?</description>
      <pubDate>Wed, 11 Apr 2018 18:39:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Loda-data-from-Excel-worksheet-tab-into-a-Collection-results-in/m-p/63089#M16085</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-04-11T18:39:00Z</dc:date>
    </item>
  </channel>
</rss>

