LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Searching from excel file

Solved!
Go to solution

@sam67 wrote:

@GerdW wrote:

Hi sam,

 

you didn't upload VI Gerd..

No, intentionally.

 

Come on: you see my example!

It's just 3 functions, two of them IndexArray and one Search1DArray. And you got an explanation, so you should be able to replicate the example on your own!

 

(By wiring yourself you learn much better than by just taking code from someone else. :D)


hahhahaha yes got it man btw thanks allot. see you in next problem 🙂


but i appreciate that if you send me this example code for example and i will save it for future  

0 Kudos
Message 21 of 96
(1,677 Views)

It return only first or last column. could you please check it again   

0 Kudos
Message 22 of 96
(1,664 Views)

Hi sam,

 

I don't see my example code in your VI: maybe that's the problem…

 

Again:

  1. Index the first row
  2. Search your desired header string
  3. Index the column where you found the header string

 

Did I suggested to use AutoCleanup before? PLEASE use it before uploading your VI (and save the VI after using it)!

Best regards,
GerdW


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

@GerdW wrote:

Hi sam,

 

I don't see my example code in your VI: maybe that's the problem…

 

Again:

  1. Index the first row
  2. Search your desired header string
  3. Index the column where you found the header string

 

Did I suggested to use AutoCleanup before? PLEASE use it before uploading your VI (and save the VI after using it)!


No, now its return only zero, i dont what i did wrong in this code. Please see the code and tell me if you can. Thanks

0 Kudos
Message 24 of 96
(1,650 Views)

Hi Sam,

 

still not my example code in your VI. I don't see where you index the first row or the column you want…

 

What's the point in replacing an array element by your string and then search that string in this array?

Best regards,
GerdW


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

@GerdW   wrote:

Hi Sam,

 

still not my example code in your VI. I do not see where you index the first row or column you want ...

 

What's the point in replacing an array element by your string and then the string in this array?


Thats the file in which I want to search the column D just and store the column D value in another array. 

According to the present invention, there is a need for a method that can be used to generate a list of indexes. Maybe i am wrong due to missunderstanding but if i am wrong then please correct me. Thanks

0 Kudos
Message 26 of 96
(1,633 Views)

sorry i forget to upload xls file. this file in .xls extension but here .xls extension is not uploaded thats why i converted it into text file

0 Kudos
Message 27 of 96
(1,630 Views)
Solution
Accepted by sam67

Hi sam,

 

why don't you just apply my example:

check.png

It consists of just 3 functions!

You fail in wiring theses 3 functions and in using AutoCleanup as well…

(From this experience I recommend to take the beginner courses offered for free in the Training section in the header of this LabVIEW board!)

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 28 of 96
(1,619 Views)

@GerdW wrote:

Hi sam,

 

why don't you just apply my example:

check.png

It consists of just 3 functions!

You fail in wiring theses 3 functions and in using AutoCleanup as well…

(From this experience I recommend to take the beginner courses offered for free in the Training section in the header of this LabVIEW board!)


Thanks allot gerd. 

0 Kudos
Message 29 of 96
(1,612 Views)

@altenbach wrote:

e.carano wrote:

I'm a beginner in using LabVIEW with datafile.


If you want code, you need to tell us your LabVIEW version.

 

If you have a recent version, you can use a conditional tunnel to simplify the code even more. (see attached 2014 version).

 


hi, i applied as it as you display in your picture but i didn't get the results. i am beginner in labview so if i could something wrong then please correct me. Thanks

please find the attached file  

Download All
0 Kudos
Message 30 of 96
(1,587 Views)