Skip to main content
DF_144820765-Regular Member
5-Regular Member
Apr 20, 2026 10:04 PM UTC
Question

copy mathcad matrix into excel like table in ansys

I am trying to copy a 1xn matrix developed in mathcad prime 11 and paste it into an excel like table in ansys mechanical to build material curves for stress analysis.  I cannot for the life of me figure out how to do what seems like a simple task.  Is this an easy thing to do?

7 replies

terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Apr 21, 2026 1:30 AM UTC

Hi,

It is a two stage process

  1. get the values into an excel spreadsheet

  2. Open Excel spreadsheet, select values, then copy and paste into ANSYS

Translate
DF_144820765-Regular MemberAuthor
5-Regular Member
Apr 21, 2026 2:58 PM UTC

interesting.  i will give it a try!

thank you for the insight.  this is great

 

Translate
DF_144820765-Regular MemberAuthor
5-Regular Member
Apr 21, 2026 3:24 PM UTC

eh it has a problem when i try to build it for ε_ps_t.  it says it must be a string or array.  any ideas?

 

Translate
terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Apr 21, 2026 5:11 PM UTC

Hi,

You need an array to save to Excel.  Your picture shows a strain function used in place of an array.  You can omit the range as the WRITEEXCEL function defaults to this if not specified.

Do it like this.  

upload your file as a zipped archive and I can show you.

Translate
anursinghCommunity Manager
Community Moderator
Jun 1, 2026 8:33 PM UTC

Hi ​@DF_14482076,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Please note that industry experts also review the replies and may eventually accept one of them as solution on your behalf.
Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,
Anurag 

Translate
Terms & ConditionsAccessibility statement