<?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 Get Worksheet as collection in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-collection/m-p/45747#M1891</link>
    <description>Hi,

I am using the standard Excel VBO object to 'Get Worksheet as Collection' and am inconsistently getting the error message 'Exception: Internal| Could not execute code stage because exception thrown by code stage: Requested Clipboard operation did not succeed'.

The spreadsheet has circa 30 columns and can be up to 1000 rows.

Is there a limit to the amount of data which can be extracted through this method? If so, can someone advise on the best solution to this?

Please note I have minimal experience of using code within Blueprism.

Many thanks</description>
    <pubDate>Mon, 27 Mar 2017 15:17:00 GMT</pubDate>
    <dc:creator>AndrewHurn</dc:creator>
    <dc:date>2017-03-27T15:17:00Z</dc:date>
    <item>
      <title>Get Worksheet as collection</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-collection/m-p/45747#M1891</link>
      <description>Hi,

I am using the standard Excel VBO object to 'Get Worksheet as Collection' and am inconsistently getting the error message 'Exception: Internal| Could not execute code stage because exception thrown by code stage: Requested Clipboard operation did not succeed'.

The spreadsheet has circa 30 columns and can be up to 1000 rows.

Is there a limit to the amount of data which can be extracted through this method? If so, can someone advise on the best solution to this?

Please note I have minimal experience of using code within Blueprism.

Many thanks</description>
      <pubDate>Mon, 27 Mar 2017 15:17:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-collection/m-p/45747#M1891</guid>
      <dc:creator>AndrewHurn</dc:creator>
      <dc:date>2017-03-27T15:17:00Z</dc:date>
    </item>
    <item>
      <title>For massive amounts of data</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-collection/m-p/45748#M1892</link>
      <description>For massive amounts of data it would always be good practice to reduce the data you are working in any one time.
There is an action that gets a worksheet range as a collection - I would recommend using this to break down what you are trying to do into smaller chunks.</description>
      <pubDate>Tue, 28 Mar 2017 15:43:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-collection/m-p/45748#M1892</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2017-03-28T15:43:00Z</dc:date>
    </item>
  </channel>
</rss>

