Return data from a cell

[Samoth]

Hi all,

I need an application that returns data from a cell (Excel). The input should be a number, then I should identify the cell of that number (in my case: cell B2) and return the contain of another cell (in my case : cell A2) . I tried with ActiveX to do that but I didn't succeed yet. If you can give some advices will be great.

Thanks!

[JK1]

Hi,

Just use the vi's attached and the task can be accompolished using these.  wire the excel application refnum and you will get the data from the selected cell range.

[Samoth]

Thanks a lot!

[JK1]

i have attached the wrong vi's in my post.  just i have re-attached them.cheers:))

[Samoth]

So firstly it should search that value in worksheet ,locate the row and column and final should return the contain of the same row but the column -1 (column found in previous step) and return that cell on the same workshhet.I'll describe you the next sample: I'm looking for the number X, I found it in cell B2 and then I should return return the containing of cell A2 that is Y. So my input is X and my output is Y.

[Julien_31]

That's a VI I sent to somebody on this forum : you will need to modify it (instead of reading 1 cell and converting it into DBL, you will need to read a cell array and converting it into DBL array, that will be the more difficult part of the job but you'll probably be able to find some examples. Then it will be easy to find the input value in the array and to find the output in that same array)