Skip to main content
J
jgraham1-Visitor
1-Visitor
February 2, 2016
Question

Using Excel Database in MathCAD

  • February 2, 2016
  • 3 replies
  • 2370 views

I've been reading through the forums but I have not found a solution to what I'm looking for. Basically, I need MathCAD 14 to read an Excel database are spit out specific values to be used in calculations.

The excel file is a list of alum. extrusions and their section properties. Below is what I want to do.

Die: 123 <--- This would be the input, the die that I want the properties for to use in the calculation.

I=x.xxx

S=x.xxx        These are the specific properties that would be auto populated based on the excel file.

J=x.xxx

and so on.

I can then use those values in different equations throughout the MathCAD sheet.

The excel file would be arranged with the Die number in column A and the output values in columns B to G (or however many property values that I would need)

Hopefully I described it well enough that someone can point me in the right direction.

3 replies

W
Werner_E25-Diamond I
25-Diamond I
February 3, 2016

You could use READEXCEL to read in the whole Excel table in a Mathcad matrix and the use the built-in "vlookup" function to get the property values as wanted-

Looks pretty straightforward.

WE

    W
    Werner_E25-Diamond I
    25-Diamond I
    February 3, 2016

    The attached file should help.

    Put the Excel sheet in the same directory as the Mathcad worksheet.

    WE

    J
    jgraham1-VisitorAuthor
    1-Visitor
    February 3, 2016

    The files you sent make sense when I look at but it is not working. Not sure if it is able to find the excel file properly. They are both in the same directory. Eventually, I will need this to be accessed by multiple people so the excel file and mathcad worksheet will not be in the same folder.

    EDIT:

    I'm not sure if Mathcad 14 has ReadExcel function but I used the READFILE function. I also had to save the excel file as 97-2003 xls file as opposed to the xlsx file. It works now, thank you.

    Terms & ConditionsAccessibility statement