Skip to main content
N
Ninetrees3-Newcomer
3-Newcomer
May 9, 2010
Question

How do I enter a table w 2000+ entries?

  • May 9, 2010
  • 1 reply
  • 2221 views
I have a complex data file that contains, among many other items, 2047 line entries, where each of these lines contains 1 integer number. I wanted to create a table of these numbers as I would in Mxx. How do I do that? In trying to paste the numbers as I would in M14, I found that the Edit ribbon box does not allow me to paste when the table|matrix cell contains data, and that data is highlighted. I must delete the cell data first. This is similar to a bug that I reported.

So...I guess that I could create an Excel file, and import or copy/paste from there --- which I attempted, only to [apparently] find that M' doesn't import xls files? At any rate, an awkward step just to get some data into M'. What am I missing?

Rich
http://www.downeastengineering.com/

1 reply

P
PhilipLeitch1-Visitor
1-Visitor
May 10, 2010
On the "Functions" tab there is a "File Access" drop down menu that contains all sorts of import options.

This is probably a clunky way of dealing with your data but it does provide more options.

Philip
___________________
Nobody can hear you scream in Euclidean space.
N
Ninetrees3-NewcomerAuthor
3-Newcomer
May 10, 2010
I'll follow up on these more, but at first blush they don't seem to do what I need. The file has different kinds of data in it. In M14, I just copy the lines of integers [in plain text format], r-click the table in M14, and select Paste Table. That gets me the data embedded in the doc, which is what I want, because I don't want to have to track the external file (even though it is archived for reference purposes in the future).

Rich
http://www.downeastengineering.com/
I
IRstuff1-Visitor
1-Visitor
May 11, 2010
MP1 only imports .XLSX files, which are the Office 2007 variety.


TTFN,
Eden
Terms & ConditionsCookie settingsAccessibility statement