<?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 I ended up writing the… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Writing-large-data-set-to-excel-is-taking-a-very-long-time/m-p/72521#M25126</link>
    <description>I ended up writing the collection to a CSV file and then importing the CSV to excel.&amp;nbsp;The change&amp;nbsp;made the excel stage finish&amp;nbsp;almost instantly.</description>
    <pubDate>Wed, 20 Jun 2018 13:46:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-06-20T13:46:00Z</dc:date>
    <item>
      <title>Writing large data set to excel is taking a very long time</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Writing-large-data-set-to-excel-is-taking-a-very-long-time/m-p/72520#M25125</link>
      <description>Hi,

I need to write 30 000 rows to excel from a collection and even when i run MS Excel VBO - Write Collection&amp;nbsp;from control room it would take several days to finish. Is there another way to write a large data set or how can i increase the speed of the process? I tried to "paste" the entire collection from my clipboard but the "paste" function in excel does not work for clipboard.

Thanks in advance for any assistance.</description>
      <pubDate>Mon, 18 Jun 2018 13:23:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Writing-large-data-set-to-excel-is-taking-a-very-long-time/m-p/72520#M25125</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-06-18T13:23:00Z</dc:date>
    </item>
    <item>
      <title>I ended up writing the…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Writing-large-data-set-to-excel-is-taking-a-very-long-time/m-p/72521#M25126</link>
      <description>I ended up writing the collection to a CSV file and then importing the CSV to excel.&amp;nbsp;The change&amp;nbsp;made the excel stage finish&amp;nbsp;almost instantly.</description>
      <pubDate>Wed, 20 Jun 2018 13:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Writing-large-data-set-to-excel-is-taking-a-very-long-time/m-p/72521#M25126</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-06-20T13:46:00Z</dc:date>
    </item>
  </channel>
</rss>

