Skip to main content
D
DF_144820765-Regular Member
5-Regular Member
April 20, 2026
Question

copy mathcad matrix into excel like table in ansys

  • April 20, 2026
  • 2 replies
  • 80 views

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?

2 replies

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 21, 2026

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

D
DF_144820765-Regular MemberAuthor
5-Regular Member
April 21, 2026

interesting.  i will give it a try!

thank you for the insight.  this is great

 

D
DF_144820765-Regular MemberAuthor
5-Regular Member
April 21, 2026

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?

 

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 21, 2026

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.

Terms & ConditionsCookie settingsAccessibility statement