Excel in Mathcad

[JM_10241707]

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.

[Werner_E]

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

[JM_10241707]

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

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

[LucMeekes]

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

Success!
Luc

[Werner_E]

Which cell? B6 ?

use something like

The assignment to a dummy variable is only necessary for the function WRITEEXCEL to actually execute.

You may as well write WRITEEXCEL( ....) =

Always attach your sheet and state, which version of Prime you are using.

[JM_10241707]

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? 

[Werner_E · Accepted solution]

---

@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

...