LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to read data from spreadsheet as a look up table

You are only reading off the first row.  You need to get the entire 2D array.  And then you need to index the Columns.  You are indexing the rows.  There is no need for the WHILE loop at all.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 11 of 18
(740 Views)

can you please attach the vi so as i get the clear idea..?

0 Kudos
Message 12 of 18
(737 Views)

@Gurmohit wrote:

can you please attach the vi so as i get the clear idea..?


Those comments were based on your VI.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 13 of 18
(729 Views)

to be true, i am new to labview, so i dont know much of it.

How do i index columns??

so just asked if you could either attach vi or a snip.

0 Kudos
Message 14 of 18
(722 Views)

Are all values guaranteed to be integers? If not, and depending on the situation, I would probably use threshold/interpolate array to return interpolated values if there is no exact match.

0 Kudos
Message 15 of 18
(720 Views)

@Gurmohit wrote:

to be true, i am new to labview, so i dont know much of it.

How do i index columns??

so just asked if you could either attach vi or a snip.


I did post a snippet earlier where I indexed the columns.  When you wire a 2D array to an Index Array, you will see two inputs for the index.  The first one is for the row and the second one is for the column.  Just wire up the second one and you got the column.

 

The Index Array is also expandable so you can index multiple items at once.  This is how I got the two columns into their own 1D arrays.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 16 of 18
(715 Views)

i tried the same, but i coudnt any result.

0 Kudos
Message 17 of 18
(700 Views)
Then it is not the same 🙂 please attach your VI.
0 Kudos
Message 18 of 18
(691 Views)