Excel in Mathcad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Excel in Mathcad
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.
Solved! Go to Solution.
- Labels:
-
Mathcad Usage
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
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
...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You may use the READEXCEL() and WRITEEXCEL() functions. Look them up in the help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Read the help info on WRITEEXCEL again to see what you should do to write data.
Success!
Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
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
...