How to write data to a file in this vi?

[Booo]

I try to use the existing vi to record the resistance data measured. It seems to me that the vi only can display the data but cannot store the data to a file (EXCEL or TXT). I tried to use "write to spreedsheet vi", but  it does not work. Could anyone give me some help? Thanks!! Both vi and picture are attached. I am very new to labview.

Thanks in advance

[Dennis_Knutson]

While you have a very old version of LabVIEW, I would recomend you check out the free tutorials.

You've made a couple of fundamental errors. First, what is exiting the while loop is only the result from the very last iteration. You can right clcik on the exit terminal and select 'Enable Indexing'. This will create a 1D array that you can pass to the Write to Spreadsheet. Second error is that the Write to Spreadsheet in 7.1 is only capable of accepting 1D or 2D DBL arrays. You will have a string array. Either convert the string result to a numeric or change the Write to Spreadsheet to accept string arrays. Directions are on the block diagram. Third, your VI can only be stopped by pressing the Abort button. That is bad design. Use a front panel Boolean wired to the termination terminal. You don't need that invert function. Just right click on the termination terminal and select 'Stop if True'

[Ray.R]

Thanks to Dennis for providing a precise & detailed description.

Since I did some changes before reading his post, I'll post the image of the code changes below.

You can use the Context Help (Help menu > Context Help, or the large Question Mark at the top rightof block diagram) to show you how to connect your data (array) to the Write To Spreadsheet File.vi.

 

Message Edited by Ray.R on 12-07-2009 01:00 PM

[Ray.R]

An observation:

I noticed that your block diagram has a red contour which indicates that you have set a breakpoint when the VI is run.  

This will pause the execution everytime you run it.  You should (probably) remove the breakpoint.

[Booo · Accepted solution]

Thank you so much for your kind help. I can save the data into a spreadsheet now. The only problem is that the data is saved in a row but not in a column.

[Ray.R]

Can you post your code and some sample data?

It may need a simple ajustment.  😉

[Booo]

The code is attached and the data is saved in a row like the attached picture. I do not know how to save it in a column. I also try to make the program to display the average, stand deviation of the data and display each data point in the plot in term of index number. So far I only can figure out how to display the min and max of data.

Thanks a lot

Booo

[Booo]

I think I solved some of the problems. Now the vi can display mean, Std, max and min. Now the problem is still the data are saved in row in spreedsheet. I want the data to be solved in a column. I attched the vi. Thanks a lot for your help.

[Dennis_Knutson]

Wire a True to the Transpose input.

[Booo]

Dennis,

       Thank you so much for your help!! Now the program seems to work well. I want to save some text information regarding the sample with the resistance data into the same file.  Could you suggest a way to do that? The Vi is attached.

Best,

Booo