string array into number

[agyna]

Hi,

I am trying to get this array of strings into numbers, from the attached file. I just need that table of values from the file.

Any help?

[crossrulz · Accepted solution]

You cannot directly read a file saved in the Excel format.  You need to save the spreadsheet as a tab delimited text file.  And after that, there are some minor tweaks that can be made to your VI to get what you want.

[agyna]

Perfect! 

Thanks a lot.

[billko]

Oh, and it's not an Excel spreadsheet, so don't name it *.xls.  Use *.txt instead.  It's a text file.  *xls will fool a computer that doesn't have Excel into thinking it cannot read it, when it is actually perfectly readable with notepad.

[ASAT]

Bill;

If I may ask a follow up question: I have a table of numbers much like the above section. How can I extract the values from, for instance, the first column, first row and first column third row? I've got a string of tab delimited information, I can get it into a chart, but I cant seem to find a way to retrieve (just) the first and third value.

i appreicate your thoughts.

[crossrulz]

Index Array