How to search through an excel spreadsheet for a number based on restrictions that you input as a user and print them out?

[Oli Oli Oxin Free]

Hi there guys

I'm trying to write a labview program and i'm new to the program. I need the program done asap. First the user inputs the row number and then based on the row number it opens and reads an excel spreadsheet file which is just a table and it outputs the numbers corresponding to the column I ask for. How do I go about doing that? I saved the file as a .lvm so Labview could read it. Its a project for school and I have no idea how to start it. Any help would be greatly appreciated.

Thanks guys a lot 

[Oli Oli Oxin Free]

the data that is in the spreadsheet is numbers

[smercurio_fc]

Ummm... what file did you save as .lvm, and what does this have to do with an Excel file? To read/write Excel files you need to use ActiveX. There are a couple of shipping examples on how to do this in LabVIEW. Plus, this has been asked like a zillion times, so there's tons of examples in this forum if you just do a search. Plus, there's an Excel thread that has lots more examples.

[Oli Oli Oxin Free]

Cant find an example that you could input the row and column and get the corresponding integer for the parameters

[Jeremy_B]

Hi,

This might help: http://sine.ni.com/devzone/cda/epd/p/id/3177

[Oli Oli Oxin Free]

Hi Jeremy

what I need exactly is to input the row and then it'll move across the row until it hits the right column name I ask for and input the integer that is in there.

Thanks a lot for the help

[smercurio_fc]

Use the Find command (example) to search the row that contains the columns. This will return a range. From the range you can get the column. Now, since you have a row and column, you can just use the part of the code provided in the previous example to get the value of the cell at the specified row and column.