Which is the best way to add a search(for an excel sheet) function for an application using LV8.0?

[LVocho]

Hi there,

    I'm new with this enviroment and I started to like it. I'm trying to find the fastest way to add a search function within an application in which I use excel based data. I'm asking this because as long as I have seen the main purpose of LabView is to gain time developing applications.

Any helpwith this will be appreciated!

Thanks!

[Joe_H]

Could you explain more about what exactly it is that you are trying to do. What do you mean about excel type data. are you using excel and want to do a search inside excel.

For more information and some sample VI's and tool kits, you can go to the excel board

[LVocho]

Yes it is actually that. I have data in an excel sheet that I need to use when a query is made in the app. It is only text data in the excel cell.

I'll review the excel board for future doubts. Thanks a lot.

[Joe_H]

on the excel board there is a vi that does a search and replace but it would not be that hard to modify to give you the cell location or whatever you need. I am still not clear exactly what are you trying to accomplish.

[LVocho]

Thanks Jhoskins, what I'm triyng to do is pull data from the excel sheet in which I have several parametric data from a part number It is a sort of parametric database. Once the part number is entered the VI looks for the parametric data and pulls it out to the app. I don't know wheater I'm using the proper method or the more effective one but I had the info already in excel and I just want to avoid extra work.

Thanks a lot for your help and interest.

[Erin_B.]

Hi LVocho,

I did a quick search and I found some interesting links that basically recommend using the Find method.  I think this should help you:

http://forums.ni.com/ni/board/message?board.id=170&message.id=94883&requireLogin=False

http://www.ozgrid.com/VBA/find-method.htm

http://forums.ni.com/ni/board/message?board.id=170&message.id=66256&requireLogin=False

Hope this helps.

Saludos,

ErinB.

NI Mexico