have an excel file with 2 columns. Want to search one and return the data from the other

[nokiaboy]

Hi,

I have an excel file that has 2 columns. i want to search the first one with a constant, then return the corresponding data in the second one to labview, preferably in some kind of string variable. is this possible and how? Thanks in advance

[Jim_Kring]

Yes, you can use ActiveX to read a table of an Excel spreadsheet. Search the examples that ship with LabVIEW, for ways to get started with this. "LabVIEW\examples\comm\ExcelExamples.llb"

Once you have your two columns, use a Search 1D array on the first column and then index out the value in the second column with the index of the found element.