Skip to main content
M
MrichCD4-Participant
4-Participant
March 19, 2019
Question

Importing Multiple Variables from Excel

  • March 19, 2019
  • 4 replies
  • 3317 views

Let's say I have two columns in an Excel document containing variable names (column A) and their associated values (column B). Is it possible to import these into MathCAD without having to type out each variable name? I've tried to finagle the excel component to do what I want but it seems no matter what I try I end up having to type the variables out by hand. This gets cumbersome because I tend to work with a lot of variables that I'd love to have auto imported.

4 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
March 20, 2019

Other posts have shown that variables cannot be auto-generated in Prime.

 

You can import the list of variables as an array of strings and their values as a multi-columned array.  The index of the string array that points to the variable name then also points to the column of values.

T
terryhendicott21-Topaz II
21-Topaz II
March 20, 2019

Hi,

 

This is undocumented but it works.  Mathcad Prime files are a zip file of xml files but with an mcdx extension.  You can alter the file extension to "zip" and the internal collection of xml files can be read by winrar or other compression software.

 

Within the zip file is a folder "mathcad". Within this folder is a file called "worksheet.xml".  Within this file is a part called "regions".  Within this part are numbered regions that define variables and their values.

 

Capture.PNG

It is possible to construct in excel this part of the file with as many variable names and values you wish.  You need to change the id, top,  variable name and value on each excel row.  Enclosed is an example.  You save the excel file (worksheet only) as formatted text *.prn.  Then use a text editor to copy the text into the xml file between the <regions>  </regions> part indicators.  Rename the xml extension as mcdx again and hey presto when you open in Mathcad the variables will be there.

 

Cheers

Terry

    F
    Fred_Kohlhepp23-Emerald I
    23-Emerald I
    March 20, 2019

    Impressive!

     

    Certainly easier that typing the variable names into mathcad.  😉

    Terms & ConditionsAccessibility statement