Skip to main content
A
AbrahamBorg1-Visitor
1-Visitor
June 17, 2011
Question

Script to create dropdown menu in Mathcad 14, that imports data from excel file

  • June 17, 2011
  • 18 replies
  • 16203 views

I need to find a way to create a drop-down menu in Mathcad that grabs material properties directly from an Excel file, and plugs them into the mathcad workspace. Could someone please point me in the right direction so that I can try to figure this out. I have attached a picture of what this dropdown menu might look like in Mathcad. The other attachment is a sample Excel file that would contain the material properties. Thank you, any help would be greatly appreciated.

18 replies

R
RichardJ19-Tanzanite
19-Tanzanite
June 17, 2011

Your jpeg shows a picture of Mathcad Prime. Mathcad Prime does not currently support any kind of component such as list boxes. Are you committed to Prime, or are you free to use Mathcad 15?

A
AbrahamBorg1-VisitorAuthor
1-Visitor
June 17, 2011

I am not commited to Mathcad Prime. I am currently using Mathcad 14.

R
RichardJ19-Tanzanite
19-Tanzanite
June 20, 2011

Somerthing like this?

V
VladimirN24-Ruby IV
24-Ruby IV
June 20, 2011

Hello!

How many types of steels you want to have in the document?

M
MikeArmstrong1-Visitor
1-Visitor
June 20, 2011

Hello!

How many types of steels you want to have in the document?

What difference would that make?

Mike

M
MikeArmstrong1-Visitor
1-Visitor
June 20, 2011

There are many different ways this can be achieved. I usually embed an Excel sheet within my Mathcad worksheet and hide it if it is not meant for display purposes.

Insert, component and select the Excel component. Then the data can be called from within your Mathcad sheet.

Mike

Terms & ConditionsAccessibility statement