Using Matlab to drive Mathcad

13 vues (au cours des 30 derniers jours)
Gregory
Gregory le 1 Août 2013
Modifié(e) : John BG le 8 Mar 2017
I am trying to use Matlab to open a Mathcad sheet, pass data and save versions of the sheet with the inserted data.
So far I can open the Mathcad sheet, insert values but cannot alter definitions (when I save the sheet the values revert to their original uncalculated state - which is what they should do).
Does anyone know the code to set definitions in Mathcad via Matlab?
Any help would be much appreciated.
h = actxserver('Mathcad.Application')
h.visible=1 % make the application visible!
h.methods % these are the methods that are available at this level
h.invoke % these are the actions that can be invoked at this level
inspect(h) % more investigation of the application inteface
h.worksheet.invoke % One level down in the interface - the worksheet level
sht = h.worksheet.Open('C:\Users\gregory.kemble\Documents\MATLAB\test_mcad_sheet.mcd') % open our MathCAD worksheet
sht.SetValue('in0',7)
sht.SetValue('in1',6)
sht.SetValue('var1',5)
sht.Save
fullname = 'C:\Users\gregory.kemble\Documents\MATLAB\new5.mcd' %sht.FullName
%new_sht = sht
sht.SaveAs(fullname)
sht.Close
h.Quit % this causes the MathCAD application attached to handle 'h' to quit
h.delete
  2 commentaires
Thomas
Thomas le 8 Mar 2017
Hello, Could you provide the mathcad file ?
Thanks
John BG
John BG le 8 Mar 2017
Modifié(e) : John BG le 8 Mar 2017
would it make sense to consider focusing on MATLAB?
if not, it's probably because Mathcad has something that MATLAB doesn't?
what would it be, the 'hc' instead of 'L'?

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Functions dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by