Searching for Specified Data, Displaying Full Row from Excel

[paintman]

Hello,

So I currently have a program that will search a pre-existing excel document (.csv) for a specified carrier number (cell value x). Once it finds the most recent carrier number it will display the part number associated with said carrier. I want to modify my code to allow me to search for the carrier number, and display the entire row (associated with that number. So say I search for carrier number in Column B, instead of just displaying the part number in Column E, I want to display the Row the data is located (A1:E1). Whether as a string or an array, I am just not sure how to go about setting it up. 

I attached the VI I currently have as a mock up that ONLY searches for the part number. To run the VI you'll need to change the Path to save dialog in the VI front panel. 

[paintman]

If someone needs an earlier version of the labview vi, just lmk and I will save it as a previous version. 

[RTSLVU]

How about something like this?

[PalanivelThiruvenkadam]

---

@paintman wrote:

Hello,

So I currently have a program that will search a pre-existing excel document (.csv) for a specified carrier number (cell value x). Once it finds the most recent carrier number it will display the part number associated with said carrier. I want to modify my code to allow me to search for the carrier number, and display the entire row (associated with that number. So say I search for carrier number in Column B, instead of just displaying the part number in Column E, I want to display the Row the data is located (A1:E1). Whether as a string or an array, I am just not sure how to go about setting it up. 

I attached the VI I currently have as a mock up that ONLY searches for the part number. To run the VI you'll need to change the Path to save dialog in the VI front panel. 

---

Hello Paintman,

If the file is of .csv (not excel) I recommend you use read delimited file and read all data.

If you still want to handle with excel, you can use as array (2D Array) and extract data using Array functions,

[paintman]

What array functions are you using in this? 

Would I need to place this in my case structure with the file path linked to it? I have never used the file I/O functions before. 

[RTSLVU · Accepted solution]

---

@paintman wrote:

What array functions are you using in this? 

---

Here's a snippet of block diagram with the labels turned on

---

@paintman wrote:

Would I need to place this in my case structure with the file path linked to it? I have never used the file I/O functions before. 

---

Basically yes