How to save data into a excel file

[Lorea]

Hello! Someone could help me telling me the correct procedure to save the data from an experiment into a spreadsheet, because I do not achieve it. I am a beginner

What I am doing is putting a block of export waveform to spreadsheet file connected to block waveform in an example of Cont Acqandgraph buffered.

When I do this, the program, save the data of the last second according to the scan rate and asks me to choose  file to write and dont save any more data from the previous moments.

I would like to know how to make the  data from all the experiment are kept on the predetermined file, not only from the last second, to handle the information later in a single file and of course have a continuous measurement, without wasting time putting the new data into a new file.

I hope you can help me

Thanks

PS I attached the picture of the diagram

[lmtis]

Hi Lorea,

To collect data continuously you need to either collect it into an array within your loop  and then pass it out to the save data VI (this array can get too large depending on how much you are collecting and how long you collect it for).  You could also put the write to spreadsheet inside the loop.  From the advanced file functions place a file dialog VI outside of the loop or a path constant to keep it from asking for an address on each iteration.  Hope this helps.

[Lorea]

Hi

When I created the array inside the loop (using buil array) and put write to spreadsheet file outside in Labview 6.0, the program seem to overwrites a single value in one cell, that is what i get when i stopped. How i save all the data in a single file for all the experiment?

I attached the example.

Thanks

[MikeS81]

Hi Lorea,
create a shift register on your while loop, use the "Append Waveform.vi" in a for loop and connect it with the shift register. Now you have all data from all loops in this waveform array. Write the data from the shift register to your file.

Mike

[Lorea]

Hi! again

The program will not let me put a shift register, when I right click on the while loop, the function is not enabled. How i do it?

Can you send me an example? please

thanks

[MikeS81]

Hi Lorea,
see the attached example.
Hope it helps.

Mike

Message Edited by MikeS81 on 06-17-2008 11:22 PM