LabVIEW Excel Link

[amalbp@gmail.com]

Greetings,

I am trying to write a LabVIEW VI that will look up a number (typed in LabVIEW) and pull up its information (found in an Excel file). For example:

| Tag ID | Blood Type | Time Donated | Designated Use |
-------------------------------------------------------
| 1234 | O+ | | Laboratory |
| 3255 | A | | Patient Room |

If I were to type, "1234" in LabVIEW, I would expect LabVIEW to link with the Excel file and pull the information and display it in LabVIEW. The "Time Donated" field will be Time Stamped in LabVIEW.

I am somewhat familiar with LabVIEW, but I am not familiar with arrays, as well as file linking. This is for a school project that is giving me a big headache. If anyone could help me, I'd greatly appreciate it.
Thanks,
Amal

[nyc_(is_out_of_here)]

Is the Excel file a "real" Excel file, or is it a file with comma-separated values?

If it is the former then you will need to use ActiveX to read the contents of the Excel file.

If it is the latter then you would read in the Excel file just as you would a text file.

LabVIEW ships with examples. I would suggest taking a look at them.

[TheDillo]

Check out the examples by going to Help -> Find Examples and searching for file, and excel.  You'll have plenty of options there.

You'll also want to check out ni.com, one possible solution I found is an actual example program Get Excel Data from Specified Field.