LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reading each value from spreadsheet file with delay (multiple rows and columns)

Hi,

a) I want to read EACH VALUE from a spreadsheet file having multiple rows and columns WITH DELAY. I am attaching my VI and sample datalog file for reference (tempsensor.txt).I need to do so because as soon as I read put ON the Sensor button on front panel, LV reads all the values at one go. I need the values for each temperature to be displayed after a delay.

b) Secondly, I would like to read another file containing the state of four antennas (deployed:1; undeployed:0). I am logging state of each antenna in each column of the file(magnet.txt) I need to have four LEDS on front panel to display state of the antennas. I dont know what I have done for antennas in my VI is right or wrong. I guess thats rhe wrong way to approach the problem. Please help!!!(column1: Antenna1 state ; Column2:Antenna2 state.. and so..on..)
Any help would be greatly appreciated!!

Thanks in advance,

Ratnesh

FYI: The first column in my datalog file represents timestamp(number of seconds elapsed), second column: reading for temperature sensor 1, third column: reading for temperature senosr 2, and so on. I am using approx. 11 temperature sensors.
Also, I have generated the log files for the reference purpose only. They do not represent the actual values. They are far away from actual values.
0 Kudos
Message 1 of 4
(2,873 Views)
Probably the easiest way to get the delay is to read the entire file and then index only the segment which has the data you want. This is a disadvantage if you have very large files (100s of MB), but in that case there are other issues as well.

Try reading the entire file(s) outside of the event structure. Put the 2D arrays into shift registers. When a sensor is selected, index that portion of the array and update the plots.

Read the Help files on array index and array subset functions to learn more about the power and versatility of these tools.

Lynn
Message 2 of 4
(2,852 Views)
hi johnsold,
Thanks for your reply. I dont understand what you are trying to say. I am a novice in LV. Please help me regarding this!!

thanks in advance,

qhunter
0 Kudos
Message 3 of 4
(2,830 Views)
Look at this modified version of your VI. After looking at it, I determined that a shift reggister was not required in this case.

Lynn
0 Kudos
Message 4 of 4
(2,810 Views)