<?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 Hi Robin, in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86407#M37264</link>
    <description>Hi Robin,
I just figured it out, it worked when I just renamed the fields after I created them so they where in the desired order, but that's seems like a really strange way it handles the Column order.</description>
    <pubDate>Fri, 28 Oct 2016 11:12:00 GMT</pubDate>
    <dc:creator>Christopher</dc:creator>
    <dc:date>2016-10-28T11:12:00Z</dc:date>
    <item>
      <title>Sorting fields when exporting to Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86405#M37262</link>
      <description>I cant really seem to figure out what the sort order is when I export a collection to Excel.
I have 2 collections that are merged to a single collection which is then exported to a Excel Sheet.
The collection does correctly enough gets exported with the fields arranges like they are in the collection in the process studio, but I can't seem to change that order, I tried to change the description and then sort by that (not sorting via a business object), but no luck.
Any suggestion?</description>
      <pubDate>Mon, 24 Oct 2016 13:52:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86405#M37262</guid>
      <dc:creator>Christopher</dc:creator>
      <dc:date>2016-10-24T13:52:00Z</dc:date>
    </item>
    <item>
      <title>Do you mean you're trying to</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86406#M37263</link>
      <description>Do you mean you're trying to change the order of the fields, or sort the values in the collection? If the latter, try sorting in Excel - it's probably more efficient for any significant amount of data. For the former, try creating a new collection with the fields in the correct order, and copying the data across in a loop.</description>
      <pubDate>Tue, 25 Oct 2016 22:44:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86406#M37263</guid>
      <dc:creator>RobinToll</dc:creator>
      <dc:date>2016-10-25T22:44:00Z</dc:date>
    </item>
    <item>
      <title>Hi Robin,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86407#M37264</link>
      <description>Hi Robin,
I just figured it out, it worked when I just renamed the fields after I created them so they where in the desired order, but that's seems like a really strange way it handles the Column order.</description>
      <pubDate>Fri, 28 Oct 2016 11:12:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-fields-when-exporting-to-Excel/m-p/86407#M37264</guid>
      <dc:creator>Christopher</dc:creator>
      <dc:date>2016-10-28T11:12:00Z</dc:date>
    </item>
  </channel>
</rss>

