How can I export results summary worksheet in Mechanical?
Tom David
Member, Employee Posts: 6
✭✭✭
How can I export the result summary worksheet to a text file through python ACT?
Tagged:
0
Answers
-
To my knowledge, access to worksheet is not yet exposed in ACT scripting. A possible workaround is to use jscript. The below code uses unsupported and undocumented commands, use at your own risk:
- analysis = ExtAPI.DataModel.Project.Model.Analyses[0] # First analysis
- analysis.Solution.Activate() #Activating solution
- ExtAPI.Application.ScriptByName("jscript").ExecuteCommand('WB.PreferenceMgr.Preference("PID_Open_Excel") = 0;') # Blocking Excel from opening after export
- ExtAPI.Application.ScriptByName("jscript").ExecuteCommand('DS.Script.toggleWorksheetVisibilityInContexMenu();') # Turn on worksheet mode with "Result Summary" section selected
- ExtAPI.Application.ScriptByName("jscript").ExecuteCommand('DS.Script.doExportWorksheetToTextFile("D:/WorsheetResult.txt");') # Exporting result, replace path in this line
0 -
If you want to execute this functionality from WB-project page, the way would be the following:
- my_system=GetSystem(Name="SYS")
- my_model = my_system.GetContainer(ComponentName="Model")
- my_model.Edit(Hidden=True)
- cmd="""analysis = ExtAPI.DataModel.Project.Model.Analyses[0]
- analysis.Solution.Activate()"""
- my_model.SendCommand(Language="Python",Command=cmd)
- cmd2="""DS = WB.AppletList.Applet("DSApplet").App;
- WB.PreferenceMgr.Preference("PID_Open_Excel") = 0;
- DS.Script.toggleWorksheetVisibilityInContexMenu();"""
- my_model.SendCommand(Language="Javascript", Command=cmd2)
- cmd3="""DS = WB.AppletList.Applet("DSApplet").App;
- var MyWait = DS.Script.AnsObjectFactory.CreateDispatchObject("WBControls.WBTestHelper.211");
- MyWait.Wait(2000);
- DS.Script.doExportWorksheetToTextFile("D:////WorsheetResult.txt");"""
- my_model.SendCommand(Language="Javascript", Command=cmd3)
- my_model.Exit()
0
