Using Matlab to drive Mathcad
6 views (last 30 days)
Show older comments
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 Comments
Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!