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

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Inputs to Table & Matrix

0 Kudos

Inputs to Table & Matrix

Is there a posibility to use copy and paste in matrix and tables, insteade of inputting the data manually specilally if we have a big number of inputs!!!!!!

13 Comments
MikeArmstrong
5-Regular Member

You can copy the data from a Matrix and paste it to another variable or you can define a variable as the data.

Can you provide an example of exactly what your after.

Mike

VladimirN
24-Ruby II

Please provide an example. I recommend to you using a built-in function "READ..." to read the files that contain the necessary data.

HarveyHensley
3-Visitor

Hinndnaser,

I was waiting for you to provide more information on what you are trying to do, but since you haven't here's my suggestion. If you have data in Excel, then your can copy the matrix as if you were going to paste it somewhere in Excel. Then, in Mathcad, create the matrix name, ; e.g. X:= and paste (cntr-V) in the cursor where a value or formula would be input. The matrix is created.

MikeArmstrong
5-Regular Member

I was waiting for you to provide more information on what you are trying to do, but since you haven't here's my suggestion. If you have data in Excel, then your can copy the matrix as if you were going to paste it somewhere in Excel. Then, in Mathcad, create the matrix name, ; e.g. X:= and paste (cntr-V) in the cursor where a value or formula would be input. The matrix is created.

What's wrong with calling Excel data from Mathcad?

Mike

VladimirN
24-Ruby II

Mike Armstrong wrote:

What's wrong with calling Excel data from Mathcad?

Mike

Agree.

HarveyHensley
3-Visitor

Mike Armstrong wrote:

What's wrong with calling Excel data from Mathcad?

Mike

Nothing, except Hinndnaser asked for a way to cut and paste to create a matrix.

h_nas
4-Participant

Cutting the middle man, I don,t want to joggle with three programs, I want to be Excel free user!!

HarveyHensley
3-Visitor

You've never said in what the program that the data you want to copy is produced. Regardless, I would try the control-c in the table in that program and control-v in Mathcad as I explained with Excel as the source. It may work.

MikeArmstrong
5-Regular Member

Fair enough, but I would have to state that I feel copying and pasting in that way is poor way of dealing with Matrices.

Mike

MikeArmstrong
5-Regular Member

Please provide a worksheet and detail exactly what you are after. This is the 10th reply to this thread and it's going no where.

Mike

joshuanknight
1-Newbie

Hello, Harvey, I am trying to do a simple copy and paste from Excel to Prime 2.0. When I hit Ctrl-V or Paste on the menu, nothing is printed. If I paste 1 value it works fine, but I need to copy a 1x440 matrix. Is it Prime 2.0 that is the problem? Thank you!

Werner_E
24-Ruby V

In Mathcad 15 you would have to type M: and then Ctrl-V and you assign the variable M a Matrix that way.

In Prime2 this does not work that way.

In Prime2 simply click on an empty space and type ctrl-V. One of those new tables is inserted and you have to fill in the headers. Unfortunately you don't get a normal matrix that way.

olivierlp
Community Manager
Status changed to: Archived

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.