csv save

[elyan]

Hi all :

Please see ]attach file , this is an simple VI that run random number , what I want to do to save these data into CSV file , with name "test1" , this CSV file its kind of excel work sheet

this is not all ,  as you see this vi run 10 time if you press on  Go bottom ,what I want every time I press Go , new result save in same file name but line under first one

 

please see attach file example

This is exactly what i want if I open the file

2- this file will be create and close automatically with non appearance on the screen

Who can I do that in labview  

Thanks

[Dennis_Knutson]

Just add a Write to Spreadsheet File to your VI. It has a an input for a 1D array. Be sure to wire a True constant to the Append to File input and wire a path control/constant so you won't be prompted for a file name each time.

[elyan]

how can i do than ,, can you please help

thanks

[johnsold]

If you want a true .csv file, change the delimiter to comma in the method suggested by Dennis. The default is tab. Excel can read tab-delimited files also. So which delimiter you choose depends on your exact specifications.

Lynn

[Dennis_Knutson]

Give it a try. This is extremely basic. You should use the free tutorials at http://www.ni.com/academic/lv_training/how_learn_lv.htm.

[elyan]

I try but it doesn't help .. i know i make some mistake some where ,,

 can you solve it

[Dennis_Knutson]

Attach what you've tried.

[elyan]

I TRY TO SEND DATA TO EXCEL ,, BUT I REACH THAT I OPEN FILE ,, THEN INSERT THE FILE NAME Manually 

what i need to save into spacific name and close excel automaticly

[Dennis_Knutson]

All you did was attach a shipping example. You did not do as I suggested and use the Write to Spreadsheet File function that is on the File I/O palette. The example will open a new Excel file but you will have to modify it to specify a file. If you use my suggestion, you can easily specify a file name. It creates a csv file that can be opened automatically by Excel. You can even give it an xls extension if you want. I happen to think that the Write to Spreadsheet is easier to use and faster for what you said you wanted to do.

If you really want to use native Excel files, then you should look at the examples posted to the Excel Board and you should also look at the Report Generation Toolkit add-on.