Read 2 Strings from EXCEL with GOOP or ActiveX?

[fuzzylogic]

Hello,
i use Labview 5.1 with WIN NT4.0 SP6a and i programm a fuzzy Logic tool for a exam in Computer Science.
Now i have a problem, and i read something about the GOOP and the EXCEL Toolkit. I download it and try more times to install but i can't link the *.llb in the Function Palette. Is this GOOP and Excel Toolkit only for Labview 6.x ?

I solve it with ActiveX and Excel, but my very big Problem is, i need to read2 string from the Excel table from the same time, and with ActiveX i don't find any method how can i do that.

I don't know how can i read 2 Strings from a Excel table, Can i do it with the Excel Toolkit,if yes how, maybe anyone make it or any helpfiles?

Thanks for your answer in advance ,

Ender
Ekinci

[Alberto]

Hi Ender,
If you want to import data from Excel spreadsheet take a look at this previous post:
http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=137&HOID=506500000005000000D3C40000&HTHREAD=000050387&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0

Good luck,
Alberto

[fuzzylogic]

Hi Alberto,
i have a Excel file with my data, but i need to read 2 Strings at the same time from the Excel table.
for Example:
y1= B11
y2= B13
the Excel file is : array.xls

So i can read only y1 or y2 but i need to read the two strings in B11 and B13 at the same time.
I hope that you can help me!

Thanks,
Ender

[Alberto]

Hi again,
I modified the example found on the link of my previous post to read only the content of two determined cells.

Hope it helps,
Alberto

[fuzzylogic]

Hi again,
thanks for your help, but i work with Labview 5.1 and i install before few minutes a Eval. Version of Labview 6.0 bu i can't open this vi to work.
I became this error:
"An error occurred loading VI'XL2000_read_2_cells[LV6.1].vi'
LabVIEW load error code 9: VI Version (6.1) is newer than LabVIEW version (6.0.1)"

Maybe you can save it as LV5.1 file ?
please help and thanks for the answers.

greetings,
Ender

[Alberto]

Here it is

[fuzzylogic]

Hi Alberto,
i try your File, but i can't run it, there are too many bad wires. I have the Problem, but i don't know why i can't save and send vi's with activeX and change on the other computer?
I try another way and it functions good but i only get the 1st String and the 2.nd String is empty.
I don't have any Bad Wires or Errors now.
Maybe is it a small failure, and you can find it.
I use Excel 97 and not Excel2000, maybe it is not the same in Labview 5.1?
I thank you very much!

my Programm is attached!
greetings,
Ender

[arussell]

"fuzzylogic" wrote in message
news:50650000000800000006780000-1042324653000@exchange.ni.com...
> Hello,
> i use Labview 5.1 with WIN NT4.0 SP6a and i programm a fuzzy Logic
> tool for a exam in Computer Science.
> Now i have a problem, and i read something about the GOOP and the
> EXCEL Toolkit. I download it and try more times to install but i can't
> link the *.llb in the Function Palette. Is this GOOP and Excel Toolkit
> only for Labview 6.x ?
>
> I solve it with ActiveX and Excel, but my very big Problem is, i need
> to read2 string from the Excel table from the same time, and with
> ActiveX i don't find any method how can i do that.
>
> I don't know how can i read 2 Strings from a Excel table, Can i do it
> with the Excel Toolkit,if yes how, m
aybe anyone make it or any
> helpfiles?

I'm pretty sure the excel toolkit is written for 5.1, and don't know why it
would give you problems. Do you have excel installed? I'm not sure what
you mean that you cant link the *.llb in function pallette. Have you tried
opening the llb using '\functions\select a vi' ? As to how to read two
cells at once, you could read a block of cells including both cells (ie:
A5..D10) and then pull the data out of the array.