LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Insert delay in reading each value from a spreadsheet file

Hi,
I just wanted to share something that any of us can have trouble solving. Its about 'Read from spreadsheet file' The number of digits precision concept. I had a hard time resolving this issue, so thought of sharing it with you all.

http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/97af6c5a6a6b1d1286256b03005a349c?OpenDocument

Also, I am trying to read multiple rows and columns from a spreadsheet file. I want to delay each value read(for each senor) from the file for a specified time so that LV doesnt read and display (XY graph) at one go.


Also I have enabled the option for'scrollbar' for X-axis but it doesnt seem to work, Can anybody explain why?


Basically my VI involves displaying the temperature data vs time accquired for 11 temperature sensors. ans some other functionalities.I have given an option of plotting multiple graphs at the same time. My sensor selection is
a boolean control array.
Other functionalities:
a) Reading the state of 4 antennas (0:Not Deployed,1:Deployed)
b) Battery Voltage reading
c) Magentometer Reading (3 Axis)
d) Current Sensors
Also, the data log files that i am attaching are for reference purpose only.
X-axis: timestamp format (HH:MM:SS). I can select multiple sensors at same time.

FYI: My datalog contains following columns:
Column1: timestamp(no.of seconds evolved since 1st Jan 1904, LV standard)
Column2: temperature data for sensor 1
Column3: temperature data for sensor 2
Column4: temperature data for sensor 3
and so..on..

I NEED SOME EXPERTS COMMENTS ABOUT HOW EFFICIENT MY VI IS FOR LARGE FILES(LIKE 100MB OR SO) AND READING MULTIPLE FILES TOGETHER. ALSO DO YOU SEE ANY MEMORY PROBLEMS COMING UP WHEN MY VI RUNS FOR A LONG TIME (SAY 2 HRS CONTINOUSLY OR LESS) PLZ COMMENT. YOUR COMMENTS ARE VALUABLE TO ME FOR MY PROJECT TO BE SUCCESS!!!

Thanks in advance,

Ratnesh

Sorry for reposting the query, as I am in a hurry to get my things working, deadline fast approaching!!! 😞
0 Kudos
Message 1 of 3
(2,618 Views)
Regarding the large file size, you should not open and close the 'Temperature' and 'Current' files every time an event is fired (the 'Read From Spreadsheet File.vi' opens and closes the file). Instead, read the files once and pass the data when an event is fired.

I don't see an increase in the memory consumption over time.
- Philip Courtois, Thinkbot Solutions

Thinkbot Solutions
0 Kudos
Message 2 of 3
(2,602 Views)
Hi Philip,
Thanks for your time and effort. You suggestions would be helpful to me in resolving any issues that I may have in VI.

Regards,

Ratnesh
0 Kudos
Message 3 of 3
(2,596 Views)