Skip to main content
M
MattLiberty1-Visitor
1-Visitor
July 18, 2013
Solved

Excel Integration

  • July 18, 2013
  • 1 reply
  • 2422 views

I am trying to create a vector in mathcad based on raw data from an excel file and i wass hoping for some help in doing this. I have been able to put an excel table into mathcad (prime 2.0), but i can't figure out how to extract the data from the excel file. Thanks for any help! I've have attached a small sample of what I would like to do.

Best answer by Werner_E

If you insist on using the Excel component you will put the appropriate commands for data extraction in the output section of that component - see attached (I recreated your Excel sheet and renamed it).

But if you just want to get the data from the excel sheet into Mathcad variables, you don't need the component but may just use READEXCEL alone. See attached two possible ways to do it.

BTW, did you come to an end with your iteration http://communities.ptc.com/message/208512#208512 ?

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
July 18, 2013

If you insist on using the Excel component you will put the appropriate commands for data extraction in the output section of that component - see attached (I recreated your Excel sheet and renamed it).

But if you just want to get the data from the excel sheet into Mathcad variables, you don't need the component but may just use READEXCEL alone. See attached two possible ways to do it.

BTW, did you come to an end with your iteration http://communities.ptc.com/message/208512#208512 ?

M
MattLiberty1-VisitorAuthor
1-Visitor
July 18, 2013

Thanks again, this should help a lot. And the iteration does precisely what I want it to do. I am still reworking my methodology and some issues with my equations but the iteration works perfectly so thank you!

M
MattLiberty1-VisitorAuthor
1-Visitor
July 22, 2013

What is the syntax if I want to convert a matrix from excel, such as a 5x5 matrix with rows F3-F7 and columns F3-J3 in this example? You can set it equal to the variable M.

Terms & ConditionsAccessibility statement