read from excel

[WeberM]

hello,
i want to read values from a table.
which is the easiest way to read?


markus

[Joe_H]

use the read from spreadsheet file function. or you could look at the shipping examples for excel or do a search on this site for activeX and you will find some examples for excel.But the easiest is the read from spreadsheet function.

Joe

[WeberM]

if i use the spreadsheet vi. it doesnt work.
i conncted the path and read the output from the vi and get always 0.000.

where's the problem?

[WeberM]

the vi works only if i save the file as *.txt.
but then i can't read strings.
is there another way to read tables with strings and values?

[Sebastian N]

Hello,

there is no simple way to do that what you want.
The only possibility, which you have is to read the titles and the values separate. If you have done this, you must transform the Values into Strings. To process the values for further calculation, you should use the numeric array. I have write a little example. The other option is that, what "jhoskins" you answer.

Hope this helps

Sebastian N
NI Germany

[Dennis_Knutson]

The easiest way to do this is to follow the instructions on the diagram of Read From Spreadsheet file to return the file contents as strings. However, since the entire contents are then strings, you would have to then convert the cells with numbers to actual values with the Scan From String function.