LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

convert ECG data( excel) into graph

Hi...
I want to make program that can read data ECG in excel form and display it in graph? Is there any example or function that can display .xls data in graph form?

Thanks
0 Kudos
Message 1 of 4
(8,474 Views)
Salutations,

Under the File I/O section there is a VI called the "Read from spreadsheet file.vi". I'd suggest saving your xls file as a CSV file (do a "save as" and make sure to say .csv instead of .xls - sometimes you'll lose formating) and then using the deliminator as a ",". If you look over that vi, you should be able to grab your desired data. Now you've got a 2-D array, so index the array (could use controls to switch it up - while loop and event structures to mess around with what is plotted) so that you get the 2 columns or rows that you desire, "bundle" them together using a "cluster" and plot them into an X-Y graph.

Now, if you want to plot multiple x-y plots, you're capable of doing that as well. Look over the x-y graph help, it'll tell you how to properly cluster and build (build array - wire in the clusters) the desired inputs. That's just about all you need really.

Of course, your X and Y array must be of the same size.

That should get you into what you desire. Now if you want to start getting fancy, investigate the use of property nodes to control the looks of your plot etc...

Sincerely,
ElSmitho
0 Kudos
Message 2 of 4
(8,470 Views)
Hi again.
Thanks for the help
Currently i'm enable to display the data in x-y graph. But,i have problem when i want to analyze the graph,Like to analyze peak to peak value, to magnify the graph. how can I analyze this XY graph like another waveform??

Thanks
Regards,
Rismi
0 Kudos
Message 3 of 4
(8,455 Views)
Hi Rismi,

If you already have code to analyze waveform data, and assuming your datapoints are evenly sampled, you can convert the X-Y data to a waveform datatype. The waveform datatype is a cluster with 3 elements: t0, dt, and an array of data points. To build a waveform, you can use the Build Waveform function located in the All Functions->Waveform palette. You can then wire a t0, dt, and your Y array (data values) to build your data into waveform datatype. You can then analyze this data with whatever code you had previously used to analyze a waveform.

Hopefully this helps,
Travis H.
LabVIEW R&D
National Instruments
0 Kudos
Message 4 of 4
(8,428 Views)