LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Searching from excel file

Solved!
Go to solution

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. 

0 Kudos
Message 1 of 96
(3,545 Views)

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

0 Kudos
Message 2 of 96
(3,513 Views)

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… :D)

 

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?

 

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 3 of 96
(3,505 Views)

could you please give me any example or same vi file

0 Kudos
Message 4 of 96
(3,501 Views)

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

0 Kudos
Message 5 of 96
(3,500 Views)

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!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 6 of 96
(3,490 Views)
0 Kudos
Message 7 of 96
(3,486 Views)

@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. 

Download All
0 Kudos
Message 8 of 96
(3,457 Views)

@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.

0 Kudos
Message 9 of 96
(3,451 Views)

@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  

0 Kudos
Message 10 of 96
(3,449 Views)