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
No products are associated with this question.
0 Comments