Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

CSV file

KesavaS
Level 2

‎08-09-18 09:20 PM

Hi  How to create CSV file? Anyone can help me please    Thanks Kesava
0 Likes
3 REPLIES 3

VaibhavGarg
Level 2

‎10-09-18 03:10 PM

I tried create CSV file using EXCEL VBO but it doesn't help as internally it creates Excel file irrespective of extension supplied.   Option 1: One option I could see is to create a CSV template for your self (one time job) and copy file & Paste on desired location every time using File Management VBO ahead of performing action. I have not tried this yet however you can try.    Option 2: Write scripting which you are comfortable in to create CSV file.
0 Likes

MetVonghiran1
Level 4

‎11-09-18 03:55 PM

I used ""Append to Text File"" in the ""Utility - File Management"".   Type the full path of the csv file that you would like to create (Example: ""p:\TEST.csv"") In an input parameter ""File Name"".   Run it, and you would see a blank CSV file in the path the you have set in the input parameter.   Regards Met Vonghiran
0 Likes

AndreyKudinov
Level 10

‎11-09-18 06:55 PM

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 (or better create new action) to something like this:     wb.SaveAs(filename, fileformat, _      Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, _         True) fileformat enum for csv is 6 True at the end makes csv ""localized"" (for example Russian excel uses comma as decimal point, and semicolon as separator), otherwise excel will save in US locale. You can check all other options on MSDN.
0 Likes