Searching from excel file

[sam67]

Hello everyone, I hope you guyz are doing well. I need your help, I want to search some integer values which maybe 100 rows and store in one array for further uses. I am confused which one algorithm is working faster in this scenario. If any recommendation or someone already did that type of searching then please help in this problem. Thanks to all. 

[Artem.SPb]

For clarity:
Do you want to take up to one hundred lines from an Excel file and then search in this data?

If yes, you need Excel get data vi. Faster will be to read all rows and then work with array in memory

[GerdW]

Hi sam,

can you explain the term "excel file"? What kind of file are you talking about? (I hope it's not the Excel EXE… )

I am confused which one algorithm is working faster in this scenario.

Do you expect a real problem with searching integers in just 100 rows?

[sam67]

could you please give me any example or same vi file

[sam67]

i wan to search data from .xls extension file. For example in header row are some integer and if i found the same string then whole selected string column will stored in another array

[GerdW]

Hi sam,

did you already tried the snippet you found in that other thread?

It does (mostly) what you need…

For example in header row are some integer and if i found the same string then whole selected string column will stored in another array

Don't mix up "integers" and "strings".

Just read the header row, search your string/integer value/whatever: if found, you can read the whole column from Excel.

And please stop posting the very same question in a lot of threads: duplicate posts aren't helpful for you nor other people!

[Artem.SPb]

use search

https://forums.ni.com/t5/LabVIEW/How-to-read-excel-file-in-LabVIEW/td-p/3244449#

[sam67]

---

@GerdW wrote:

Hi sam,

did you already tried the snippet you found in that other thread?

It does (mostly) what you need…

For example in header row are some integer and if i found the same string then whole selected string column will stored in another array

Don't mix up "integers" and "strings".

Just read the header row, search your string/integer value/whatever: if found, you can read the whole column from Excel.

And please stop posting the very same question in a lot of threads: duplicate posts aren't helpful for you nor other people!

---

First all sorry man. I got it. 2nd i need your help if you can do this. Thats my VI file. I need to store selected column in array but currently it store row just. maybe through picture you understand more. 

[Artem.SPb]

---

@sam67 wrote:

First I need to store selected column in array but currently it store row just. maybe through picture you understand more. 

---

It seems that you are trying to guess how to combine functions, and you do not understand what each function does.

[sam67]

---

@Artem.SPb wrote:

---

@sam67 wrote:

First I need to store selected column in array but currently it store row just. maybe through picture you understand more. 

---

It seems that you are trying to guess how to combine functions, and you do not understand what each function does.

---

Maybe yes because i am new in labview and i dont have time to learn it from beginning thats why i posted again and again and try to implement myself. If you understand this code and if you correct it and please help me. Thanks