<?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 Collection to Excel in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-Excel/m-p/81922#M33436</link>
    <description>Hi,

I'm currently working on a process where I am moving 3 separate collections (each collection is 6000 lines) into a single Excel workbook. I'm using the Excel VBO "Write Collection", however the process is takes around 5 minutes per collection to write to excel when I write to a new blank workbook. When I try write it to an existing workbook with data in different worksheets, it takes over an hour per collection to compile.

Is there a more efficient way of writing collections to excel?

Thanks,
Richard</description>
    <pubDate>Wed, 26 Apr 2017 23:27:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2017-04-26T23:27:00Z</dc:date>
    <item>
      <title>Collection to Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-to-Excel/m-p/81922#M33436</link>
      <description>Hi,

I'm currently working on a process where I am moving 3 separate collections (each collection is 6000 lines) into a single Excel workbook. I'm using the Excel VBO "Write Collection", however the process is takes around 5 minutes per collection to write to excel when I write to a new blank workbook. When I try write it to an existing workbook with data in different worksheets, it takes over an hour per collection to compile.

Is there a more efficient way of writing collections to excel?

Thanks,
Richard</description>
      <pubDate>Wed, 26 Apr 2017 23:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-to-Excel/m-p/81922#M33436</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-04-26T23:27:00Z</dc:date>
    </item>
  </channel>
</rss>

