how to save data in CSV format

[hofer]

Hi,Iam reading data continuously and I want to save this data in CSV OR excel format,please explain with example how i can do this as, iam a beginner.

[Dennis_Knutson]

Use the function Write To Spreadsheet File on the File I/O palette. There is an input called delimiter. It defaults to a tab character but you can wire a comma string constant to it and get comma separated. Excel will read either comma or tab separated data.

[hofer]

Thank u very much for ur reply,can u send me an example.I could not understant completely.

[Dennis_Knutson]

Look at my attachment here. It has a Write to Spreadsheet File function with a space as a delimiter. Just replace the space with a comma.

A function like this is pretty easy to experiment with. All you have to do is open the VI, enter some data, and run it.

[Roy_F]

Hofer,

Don't forget to search help when looking for how to do something. You will get some helpful results if you search for comma delimited. Unfortunately, CSV is a complete miss (I'll file that as a bug). Once within help, there are often links that will take you directly to an example and/or to related examples.

For example, if you hover over Write to Spreadsheet File (either on a block diagram or a palette) and then click on the Context Help windows ? button or "click here for more help" link, it will open online help on that function. Near the top of the online help is a link to an example.

You can also use the Example Finder (via Help >> Find Examples) when specifically looking for examples.

Enjoy,

Roy