topic Re: Excel in Mathcad in Mathcad

Excel in Mathcad

JM_10241707 — Wed, 03 May 2023 17:13:56 GMT

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.

Re: Excel in Mathcad

Werner_E — Wed, 03 May 2023 18:15:31 GMT

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

Re: Excel in Mathcad

JM_10241707 — Wed, 03 May 2023 19:47:49 GMT

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

Re: Excel in Mathcad

LucMeekes — Wed, 03 May 2023 20:34:59 GMT

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

Success!
Luc

Re: Excel in Mathcad

Werner_E — Wed, 03 May 2023 20:42:46 GMT

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.

Re: Excel in Mathcad

JM_10241707 — Fri, 05 May 2023 20:02:32 GMT

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?

Re: Excel in Mathcad

Werner_E — Sat, 06 May 2023 00:20:37 GMT

@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

...