Skip to main content
P
PF_140481661-Visitor
1-Visitor
August 25, 2025
Question

Creating equations using data from Excel in Prime 9

  • August 25, 2025
  • 2 replies
  • 787 views

As an electrical engineer who performs worst case analysis of electrical circuits, I'd like to automate this task.  I'd like to take a parts list in Excel, and have Mathcad create the definitions for each part.  For example, my parts list has R1, 100 ohms.  I want Mathcad Prime to make the equation R1:=100Ω.

 

Is there a way to do this?

2 replies

W
Werner_E25-Diamond I
25-Diamond I
August 25, 2025

I would suggest that you read in the data via READEXCEL.

If you have the values of, for example, three resistors in cells B2 to B4, you could read all three into three variables in one go and immediately assign them the correct unit.

Werner_E_0-1756147362303.png

In this example I used literal indices, so creating three different variables. Of course you also could read in the data in just one vector whose elements you can access using vector/matrix indices. As I usually never change the value of the system variable ORIGIN from its default value zero, the first elelement is accessed with index 0

Werner_E_1-1756147556109.png

 

 

S
StuartBruff23-Emerald V
23-Emerald V
August 25, 2025

Hi Werner,

 

Another option might be to use the Excel-to-Python-Function converters and see if the resulting output can be massaged into a suitable form for automation via one of the Advanced Controls (now that the Python Scripting Language is available - I haven't tried it yet).

 

Alternatively, somebody (ie, not me) could try writing a script to create a worksheet using the Excel names to plug in regions with appropriately-named variables.   But that sounds like work.

 

Stuart

A
anursinghCommunity Manager
Community Moderator
September 30, 2025

Hi @PF_14048166,

 

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 

Terms & ConditionsCookie settingsAccessibility statement