<?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 Or you can rewrite it using… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58824#M12593</link>
    <description>Or you can rewrite it using normal interop calls instead of copy-paste used in VBO, which has it's own downsides, but works better in most cases.</description>
    <pubDate>Wed, 20 Feb 2019 23:50:00 GMT</pubDate>
    <dc:creator>AndreyKudinov</dc:creator>
    <dc:date>2019-02-20T23:50:00Z</dc:date>
    <item>
      <title>Get worksheet as collection : Values</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58820#M12589</link>
      <description>When&amp;nbsp; I use "get worksheet as collection", the values fetched into the collection are the ones that are displayed on the sheet and not the actual cell value. For instance, 5.87 displays 5 but when we click on the cell it is 5.87. Using "Get cell value" fetches 5.87, however, get collection gives 5. I need to use get collection since I have a huge excel sheet and I need to fetch these decimal points as well.&amp;nbsp;

&amp;nbsp;

Any help would be appreciated.

Thanks.</description>
      <pubDate>Wed, 02 Jan 2019 14:41:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58820#M12589</guid>
      <dc:creator>NupurSood</dc:creator>
      <dc:date>2019-01-02T14:41:00Z</dc:date>
    </item>
    <item>
      <title>At present, per my knowledge…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58821#M12590</link>
      <description>At present, per my knowledge, &amp;nbsp;There is no direct solution though the work around should be changing the excel format to display decimals with ""increase decimal option.</description>
      <pubDate>Thu, 03 Jan 2019 12:04:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58821#M12590</guid>
      <dc:creator>Jagan_MohanP</dc:creator>
      <dc:date>2019-01-03T12:04:00Z</dc:date>
    </item>
    <item>
      <title>Was looking was an optimized…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58822#M12591</link>
      <description>Was looking was an optimized way since my excel is has mixed data (including percentages, text etc.) and a lot many columns</description>
      <pubDate>Thu, 03 Jan 2019 13:11:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58822#M12591</guid>
      <dc:creator>NupurSood</dc:creator>
      <dc:date>2019-01-03T13:11:00Z</dc:date>
    </item>
    <item>
      <title>Hello,
Instead of using MS…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58823#M12592</link>
      <description>Hello,
Instead of using MS Excel VBO, use OLEDB VBO's ""Get Collection"" action (write an SQL query) to bring those values as it is.
Good Luck.</description>
      <pubDate>Mon, 07 Jan 2019 09:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58823#M12592</guid>
      <dc:creator>SukeshManthena</dc:creator>
      <dc:date>2019-01-07T09:55:00Z</dc:date>
    </item>
    <item>
      <title>Or you can rewrite it using…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58824#M12593</link>
      <description>Or you can rewrite it using normal interop calls instead of copy-paste used in VBO, which has it's own downsides, but works better in most cases.</description>
      <pubDate>Wed, 20 Feb 2019 23:50:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-worksheet-as-collection-Values/m-p/58824#M12593</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-02-20T23:50:00Z</dc:date>
    </item>
  </channel>
</rss>

