<?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 Get data from csv file - &amp;quot;Get Worksheet As Collection (Fast)&amp;quot; in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-data-from-csv-file-quot-Get-Worksheet-As-Collection-Fast/m-p/52406#M7283</link>
    <description>Hi

&amp;nbsp;

I'm having trouble to read data from a csv file and insert it correctly to a collection.

It's like even the colums in the csv file is separated by ",", the action "Get Worksheet As Collection (Fast)" inserts one row in one colum in the collection.

The exact same process/object works with a colleague.

&amp;nbsp;

If I make a workaround by converting the csv to txt and then to excel (now separated in colums) then the&amp;nbsp;action "Get Worksheet As Collection (Fast)" inserts data in different colums in the collection.

&amp;nbsp;

The workaround should not be necessary - any suggestions for what goes wrong with the csv file?

&amp;nbsp;

Best reagards

Deniz Karakaplan

&amp;nbsp;</description>
    <pubDate>Thu, 25 Oct 2018 15:09:00 GMT</pubDate>
    <dc:creator>DenizKarakapaln</dc:creator>
    <dc:date>2018-10-25T15:09:00Z</dc:date>
    <item>
      <title>Get data from csv file - "Get Worksheet As Collection (Fast)"</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-data-from-csv-file-quot-Get-Worksheet-As-Collection-Fast/m-p/52406#M7283</link>
      <description>Hi

&amp;nbsp;

I'm having trouble to read data from a csv file and insert it correctly to a collection.

It's like even the colums in the csv file is separated by ",", the action "Get Worksheet As Collection (Fast)" inserts one row in one colum in the collection.

The exact same process/object works with a colleague.

&amp;nbsp;

If I make a workaround by converting the csv to txt and then to excel (now separated in colums) then the&amp;nbsp;action "Get Worksheet As Collection (Fast)" inserts data in different colums in the collection.

&amp;nbsp;

The workaround should not be necessary - any suggestions for what goes wrong with the csv file?

&amp;nbsp;

Best reagards

Deniz Karakaplan

&amp;nbsp;</description>
      <pubDate>Thu, 25 Oct 2018 15:09:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-data-from-csv-file-quot-Get-Worksheet-As-Collection-Fast/m-p/52406#M7283</guid>
      <dc:creator>DenizKarakapaln</dc:creator>
      <dc:date>2018-10-25T15:09:00Z</dc:date>
    </item>
    <item>
      <title>Use Show action - means your…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-data-from-csv-file-quot-Get-Worksheet-As-Collection-Fast/m-p/52407#M7284</link>
      <description>Use Show action -&amp;nbsp;means your excel opens csv this way. Find out why. May be locale specific.&amp;nbsp;
Consider reading csv directly, although parsing csv has it's own caveats.</description>
      <pubDate>Thu, 25 Oct 2018 16:11:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-data-from-csv-file-quot-Get-Worksheet-As-Collection-Fast/m-p/52407#M7284</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2018-10-25T16:11:00Z</dc:date>
    </item>
  </channel>
</rss>

