<?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 If you need to save… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79670#M31524</link>
    <description>If you need to save collection as csv, you should probably just concatenate and write it yourself.
If you want to save existing excel as csv, you'll need to change save action&amp;nbsp;(or better create new action) to something like this:
&amp;nbsp;&amp;nbsp;&amp;nbsp; wb.SaveAs(filename, fileformat, _
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, _
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; True)
fileformat enum for csv is 6
True at the end&amp;nbsp;makes&amp;nbsp;csv ""localized"" (for example Russian excel&amp;nbsp;uses comma as decimal point, and semicolon as separator), otherwise excel will save in US locale.
You can check all other options on MSDN.</description>
    <pubDate>Tue, 11 Sep 2018 17:55:00 GMT</pubDate>
    <dc:creator>AndreyKudinov</dc:creator>
    <dc:date>2018-09-11T17:55:00Z</dc:date>
    <item>
      <title>CSV file</title>
      <link>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79667#M31521</link>
      <description>Hi&amp;nbsp;

How to create CSV file?

Anyone can help me please&amp;nbsp;

&amp;nbsp;

Thanks

Kesava</description>
      <pubDate>Sat, 08 Sep 2018 20:20:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79667#M31521</guid>
      <dc:creator>KesavaS</dc:creator>
      <dc:date>2018-09-08T20:20:00Z</dc:date>
    </item>
    <item>
      <title>I tried create CSV file…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79668#M31522</link>
      <description>I tried create CSV file using EXCEL VBO but it doesn't help as internally it creates Excel file irrespective of extension supplied.
&amp;nbsp;
Option 1:
One option I could see is to create a CSV template for your self (one time job) and copy file &amp;amp; Paste on desired location every time using File Management VBO ahead of performing action.
I have not tried this yet however you can try.&amp;nbsp;
&amp;nbsp;
Option 2:
Write scripting which you are comfortable in to create CSV file.</description>
      <pubDate>Mon, 10 Sep 2018 14:10:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79668#M31522</guid>
      <dc:creator>VaibhavGarg</dc:creator>
      <dc:date>2018-09-10T14:10:00Z</dc:date>
    </item>
    <item>
      <title>I used ""Append to Text File""…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79669#M31523</link>
      <description>I used ""Append to Text File"" in the ""Utility - File Management"".
&amp;nbsp;
Type&amp;nbsp;the full path of the csv file that you would like to create (Example: ""p:\TEST.csv"") In an input parameter ""File Name"".
&amp;nbsp;
Run it, and you would see a blank CSV file in the path the you have set in the input parameter.
&amp;nbsp;
Regards
Met Vonghiran</description>
      <pubDate>Tue, 11 Sep 2018 14:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79669#M31523</guid>
      <dc:creator>MetVonghiran</dc:creator>
      <dc:date>2018-09-11T14:55:00Z</dc:date>
    </item>
    <item>
      <title>If you need to save…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79670#M31524</link>
      <description>If you need to save collection as csv, you should probably just concatenate and write it yourself.
If you want to save existing excel as csv, you'll need to change save action&amp;nbsp;(or better create new action) to something like this:
&amp;nbsp;&amp;nbsp;&amp;nbsp; wb.SaveAs(filename, fileformat, _
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, _
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; True)
fileformat enum for csv is 6
True at the end&amp;nbsp;makes&amp;nbsp;csv ""localized"" (for example Russian excel&amp;nbsp;uses comma as decimal point, and semicolon as separator), otherwise excel will save in US locale.
You can check all other options on MSDN.</description>
      <pubDate>Tue, 11 Sep 2018 17:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/CSV-file/m-p/79670#M31524</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2018-09-11T17:55:00Z</dc:date>
    </item>
  </channel>
</rss>

