Skip to main content
8-Gravel
May 3, 2023
Solved

Excel in Mathcad

  • May 3, 2023
  • 1 reply
  • 2165 views

I want to get the input from excel do the calculation in Mathcad prime and return the output to same excel sheet is it possible.

 

Best answer by Werner_E

@JM_10241707 wrote:

Thank @Werner_E for the information I misread Helpcenter. I wanted to add the value from excel to Mathcad prime make the calculation without opening the worksheet in Mathcad prime and return the result to same or different excel file do you think it is doable in prime based on some sort of script? 


Doing calculations in Prime without opening Prime?? You'd like to call Prime from within a VB script from within Excel, I guess. Thats possible to do using the Prime API. I have no experience in doing so, so i can't help any further.

Just look up  the informations in the help and I also remember a couple of threads here in the forum dealing with the subject.

Automation API

Getting Started with the PTC Mathcad API | PTC | Mathcad

Solved: Prime 8: Cant use API with Excel - PTC Community

Solved: API: Excel and Prime. VBA timing issues? - PTC Community

...

1 reply

25-Diamond I
May 3, 2023

You may use the READEXCEL() and WRITEEXCEL() functions. Look them up in the help.

8-Gravel
May 3, 2023

I tried to look into Helpcenter but not getting the expected results maybe I am doing something wrong 

JM_10241707_0-1683143235182.png

I want to write result D in specific cell of excel that I am unable to do 

23-Emerald IV
May 3, 2023

Read the help info on WRITEEXCEL again to see what you should do to write data.

 

Success!
Luc