cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

How do I enter a table w 2000+ entries?

Ninetrees
1-Newbie

How do I enter a table w 2000+ entries?

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/
6 REPLIES 6

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.

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/

MP1 only imports .XLSX files, which are the Office 2007 variety.


TTFN,
Eden

Rich,

Did you try the Data Filename button on the Data/Matrix tab to import your data file?

There are some new read and write data functions, like READCVS.

Mona

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/
MikeArmstrong
5-Regular Member
(To:Ninetrees)

On 5/11/2010 8:52:57 PM, woodwise wrote:
>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/

I am having the same issue. Embedded components are not in Prime 1.0

Regards

Mike
Top Tags