Skip to main content
D
dtrinconi1-Visitor
1-Visitor
July 21, 2016
Question

How to define a variable on MathCad from an Excel.

  • July 21, 2016
  • 3 replies
  • 5534 views

Hey guys, sorry in advanced if this is an ongoing discussion here, I tried hard to find something similar but I couldn't.

My problem is: I already have an mathcad file doing all the calculation i need with the necessary inputs as thickness, width, etc. I would like to be able to change these inputs using values from an excel spreadsheet.

I already figured it out how to do using the SetValue function on VBA, but the problem is that once I close the mathcad, this modification is gone. I read somewhere that this kind of manipulation is only possible changing the XML file, is that correct? Do you guys know if there is a different and simple solution for the MathCad 15?

Thanks in advance!

Denis.

3 replies

-
-MFra-21-Topaz II
21-Topaz II
July 21, 2016

Hello Denis, you can follow the steps shown, to import an Excel .xlsx file.

Greetings

FM

importare un file excel.jpg

    D
    dtrinconi1-VisitorAuthor
    1-Visitor
    July 22, 2016

    Thanks for your answer!

    By now it would be better if I didn´t have an excel file embeded on the mathcad file, I´ll try to do it from outside the mathcad.

    But I´ll defenetly use this as an alternative option.

    Thanks very much!

    R
    RichardJ19-Tanzanite
    19-Tanzanite
    July 21, 2016

    You can modify the XML of a math region via the automation interface. I've attached a worksheet with a button that does this using a vbscript. It should be easy enough to convert the script to VBA,

      D
      dtrinconi1-VisitorAuthor
      1-Visitor
      July 22, 2016

      Hello Richard, thanks for your quick answer!

      Unfortunatly I could not figure it out how does this worksheet work. If it is possible, could you please share more info about it?

      Thanks very much!! =D

      R
      RichardJ19-Tanzanite
      19-Tanzanite
      July 25, 2016

      It is possible to modify the XML of a math region via the automation interface. You can read or write the XML as a string to the region.MathInterface.XML property. That's easy to do as long as you know what the XML is supposed to be, and you can find the correct region in the regions collection. So, to find the region you have to set it's tag (right click on it, select properties). This piece of code:

      simply steps through the worksheets regions collection until it finds the one with the correct tag, and then exits. Almost of the remaining code builds the XML for the region. It is overkill for what you want to do though, because it creates the XML from scratch, and it creates a complicated expression with a list of variable names in a matrix on the LHS and the values to assign to them in a matrix on the RHS. In your case, if you have an existing assignment all you need to do is read the XML, change the number, and write it back again. I have attached another worksheet that makes it easy to look at the XML structure for any math region. Just create the region you want to examine, give it a tag, and then point the list box at it by putting the tag in the input variable. For a simple assignment like X:=23 the XML looks like this:

      You need to replace the "23" and write the XML back to the region (and then save the worksheet of course!)

      A
      AlvaroDíaz12-Amethyst
      12-Amethyst
      July 23, 2016

      Hi Denis.

      Sorry, but can't understand what do you want. You close mathcad and modifications are gone? From where? From an Excel file? You can use inputs from an excel file, make some calculus, and save the outputs to the same excel file or another one. Both with a data component (data import wizard).

      Best regards.

      Terms & ConditionsAccessibility statement