There are two issues here: reading a data file, and pasting a data table, a la M14.
I copied the data and pasted it into a 2007 Excel worksheet, and used READEXCEL to read the file. There are two difficulties with this process: first, I don't want to create an Excel file just to get the data into M', and second, the READEXCEL doesn't always read the file. I think the latter problem has to do with the M' default dir, because the READEXCEL function embedded ".\\Co60 @ 20cm 30s.Spe.xlsx" in to my M' doc, and perhaps the PWD is not always where the data is.
The real issue for me is the overhead of a) having to create the Excel data file, and b) then keeping track of the data file so that it is always available to be read in. Maybe I am missing a point wrt the Excel read file routines? Do any of them embed the data so that the file is no longer needed? In M14, when I select "Paste Data Table," the data is embedded in the M14 doc.
Rich
http://www.downeastengineering.com/