I have issues when reading from excel file

[programmindragon]

I am trying to read from an excel spreadsheet and write these numbers into a two dimensional array.  It connects and does not throw any errors but when I add probes to it, neither the array size nor the data is correct.

When i run it, I get 12x4 or 12x5 or 12x6.... and the numbers are always zero.  I know the file exists, so are there some settings in excel that I must change?

Thanks in advance for your help.

[Dennis_Knutson]

Is this file a native xls file or one you saved as a comma/tab separated text file? A native Excel file is not a text file and if you want to read one, you have to use ActiveX. The Read From Spreadsheet File function is not Read From Excel Spreadsheet. It is written to only read from generic spreadsheet files. Do a Save As in Excel to create the comma or tab separated file.

[programmindragon]

Thanks Dennis.  That solved my issue.