<?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 Excel Sort in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Excel-Sort/m-p/68196#M20801</link>
    <description>Hi

Can anyone advise how I can sort data in Excel using Blue Prism?

I have a worksheet with approx. 80,000 rows and 50 columns that I need to sort.  I have tried loading to a collection and using the Collection Sort Utility but it fails with an OutOfMemory error.

Thanks</description>
    <pubDate>Mon, 26 Jun 2017 15:20:00 GMT</pubDate>
    <dc:creator>NiallFee</dc:creator>
    <dc:date>2017-06-26T15:20:00Z</dc:date>
    <item>
      <title>Excel Sort</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Sort/m-p/68196#M20801</link>
      <description>Hi

Can anyone advise how I can sort data in Excel using Blue Prism?

I have a worksheet with approx. 80,000 rows and 50 columns that I need to sort.  I have tried loading to a collection and using the Collection Sort Utility but it fails with an OutOfMemory error.

Thanks</description>
      <pubDate>Mon, 26 Jun 2017 15:20:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Sort/m-p/68196#M20801</guid>
      <dc:creator>NiallFee</dc:creator>
      <dc:date>2017-06-26T15:20:00Z</dc:date>
    </item>
    <item>
      <title>You will have to use a code…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Sort/m-p/68197#M20802</link>
      <description>You will have to use a code stage with VB</description>
      <pubDate>Tue, 10 Apr 2018 19:31:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Sort/m-p/68197#M20802</guid>
      <dc:creator>NevilleWatson</dc:creator>
      <dc:date>2018-04-10T19:31:00Z</dc:date>
    </item>
  </channel>
</rss>

