02-16-2017 06:06 PM
Hi there,
i was trying to save data from three different sensors at the end of while loop (auto indexing) in a single spread sheet. i tried conncting all the thrree using build array and then to the write to spreadsheet vi, but im not getting the result i wanted to see. can somebody help.
Regards,
tjyu
02-16-2017 06:18 PM
What is wrong with your data format? Could you share some code so we know what you have?
02-16-2017 10:47 PM
02-17-2017 08:42 AM
I expected to see three columns each of 5000 rows as i acquired data at the rate of 1000Hz for 5 seconds instead i had 3 columns each of a single row. thanks
I eddd
02-17-2017 08:53 AM
You probably just stored the very first or, more likely, very last value because you didn't build your arrays correctly. We can only guess until you post your code. Post your VI itself, not a picture please.
02-17-2017 09:41 AM
@tjuy wrote:
Hi there,
i was trying to save data from three different sensors at the end of while loop (auto indexing) in a single spread sheet. i tried conncting all the thrree using build array and then to the write to spreadsheet vi, but im not getting the result i wanted to see. can somebody help.
Regards,
tjyu
Sounds like you are doing it wrong. That's about all the help we can give without seeing your code.
But without seeing anything, I have to ask why are you only writing at the end of a while loop?
Assuming you are taking measurements on every iteration of your loop, you should also be writing a line of data to your file on every iteration of your loop.
02-17-2017 11:33 AM
Hi there,
find attached is the VI. for both cases (inside and outside the Loop) i expected to see 2 columns of 176400 rows each in the file using a sampling frequency of 44100Hz running for a period of 4 seconds. for the case of outside the loop , i used shift registers to be remembering the previous stages of the wafeform. please help in both cases so that i can go for the most cost effective one (memory).
Thanks.
02-17-2017 12:16 PM
Use the Export Waveforms To Spreadsheet File VI instead of the Write To Spreadsheet File.
02-17-2017 01:57 PM
Let me guess, You are really getting errors out of the Append Waveform.vi since the dT's do not match. (1/44100 != 22.7e-6)
02-17-2017 03:34 PM
The problem is not exporting the data, is all about what vi can i use to concatenate the waveforms and have them in a seperate columns in the file (was meaning saving all the waformsin one file).
Thanks.