0

I would like to write a string in he columns of a csv file using javascript. I'm using the below code, but it writes the entire string in 1 column.

var header="Number" + ',' + "Name" + ',' + "Description" + '\n' ;

this is how I create the csv fie:

 var fso = new ActiveXObject("Scripting.FileSystemObject"); var s = fso.CreateTextFile("C:\\REPORT.csv");

Any suggestions?

Improve this question
3
  • How exactly are you creating the CSV file itself? Also, you could just put all of that in one string... header = "Number","Name","Description"\n Commented Aug 19, 2015 at 8:39
  • i updated my question, also I changed the string as per your sugestion, but didnt help in splitting into different column. I also opened in excel, but all was writen in 1 column. Commented Aug 19, 2015 at 8:48
  • stackoverflow.com/questions/14964035/… Commented Aug 19, 2015 at 9:37

2 Answers 2

Reset to default
1

There's nothing wrong with your code. There are few CSV standards which can use different character for separator, e.g. USA/UK CSV uses comma for separator, while European CSV/DSV uses semicolon for separator.

You just should make sure that your viewer is properly configured, in OpenOffice Calc when you try to open CSV, you see the following window prompt where you can select the right separator.

If you're using Excel: How to correctly display .csv files within Excel 2013?

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks a lot Unixarmy. It was the wrong separator. after using ";", i got the desired output. Is it possible to specify the cell width to fit the long string.
You can't do this using CSV.
0

There's also an option in Windows to control the separator :

Go to "Control Panel"/"Region and Language"/"Change the date, time or number format". In the "Region and Language" window that opens, click "Additional settings..." in the "Format" Tab.

On the "numbers" tab, there is a "list separator" which you can choose between semicolon (;) and comma (,). When applying the changes and opening the file with excel again, it will be all good.

The only problem with that solution is it changes the entire system separator. So if you have other files with semicolon separator you want to open in excel, then you will have to import it as text file and change some parameters...

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.