Skip to main content
P
ptc-30312211-Visitor
1-Visitor
June 26, 2012
Question

Bringing symbolic variables out of excel

  • June 26, 2012
  • 1 reply
  • 3289 views

At several points, I've been interested in typing symbolic variables into MS Excel, or even short sequences of calculations, and then importing them into Mathcad, and having Mathcad recognize them as symbolic variables or functions, but I could never figure out how to do this. I tried to use the string function that converts strings to numbers (str2num), but it seemed to only work for strings that were actual numbers (like '56', not like 'x'). Is there a way to do this?

1 reply

R
RichardJ19-Tanzanite
19-Tanzanite
June 26, 2012

No, there is no realistic way to do what you are asking. In principle you could write a VBA program in Excel that would modify the XML of a Mathcad worksheet. In practice that would be a major undertaking though, and hardly likely to be worth the effort.

P
ptc-30312211-VisitorAuthor
1-Visitor
June 27, 2012

Mr. Jackson,

Thanks for the advice. I have found efficient ways to avoid needing to do this so far, but I feel like I might want to do it at some point for something. You're right, I don't want to go to the trouble of using VBA code in Excel to accomplish this.

Thanks!

M
MikeArmstrong1-Visitor
1-Visitor
July 3, 2012

Why use excel at all then?

Mike

Terms & ConditionsCookie settingsAccessibility statement