read Sampling Time + Voltage Data from Excel and Display in a Graph

[Xiaogang]

I have the recorded data in an Excel file in flowing format.

The first column is sampling time, the rest four columns are analog data from 4 channels.

9/16/2005 13:45:17

0

-0.001

-0.001

-0.001

Does anyone know how to read and display these data in one graph, with the X-axis showing sampling time and Y-axis showing analog data? Or do you know how to read the first column as Data + Time data?

Thank you very much for your kind help.

 

Message Edited by Xiaogang on 09-16-2005 01:06 AM

[chilly_charly]

Here is a way to convert your string to a time stamp. You can further convert it to U32 or a Dble if required.

[Xiaogang]

Hi, chilly charly,

Thanks a lot for your reply. I am a LabVIEW beginner, but it is really very nice to have a place to ask questions and get your help on LabVIEW.

I will change my program with hints from you.

I also attached my progrma to share with you all.

In the program, i insert one more column in Excel sheet to record the absolute time in the unit of seconds (to avoid overflow, all data are minused by a constant), so that I can plot X-Y graph and calculate the elapesd testing time.

[Xiaogang]

Recorded Data File.

SelectCh.vi attached above is a subVI for the main program.

[篮球之鬼]

You don't have to use XY Graph and dynamic data. Try this one.

[Xiaogang]

hi, Daniel,

Thanks a lot for your help.

It is very nice to see your name in Chinese ---"篮球之鬼".

BTW, happy moon-cake day! *^_^*

[篮球之鬼]

3q. Happy mid-autumn festival