The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Dim MonarchObj As New Datawatch.Desktop.Automation.MonarchAutomationObject
dim ok as boolean = MonarchObj.SetReportFile("c:\temp\Classic.prn", strPassword, bAppend)
dim b1 as booleana = MonarchObj.SetModelFile("c:\temp\Lesson9.dmod")
dim b2 as Boolean = MonarchObj.SetProjectFile("c:\temp\pivot.dprj")
MonarchObj.RunAllExports()I tried the above script and the export contained two tabs, for was the table export and another one was the pivot.RegardsMo
Hi Al,To export a Monarch Classic table to an Excel file with pivot, perform the following steps:Create an export in Monarch Classic,Save the model and the project file,you can run the project in the com object per following scripts:Make sure you add Monarch.exe to the Visual Studio project referenceDim MonarchObj As New Datawatch.Desktop.Automation.MonarchAutomationObject dim ok as boolean = MonarchObj.SetReportFile("c:\temp\Classic.prn", strPassword, bAppend) dim b1 as booleana = MonarchObj.SetModelFile("c:\temp\Lesson9.dmod") dim b2 as Boolean = MonarchObj.SetProjectFile("c:\temp\pivot.dprj") MonarchObj.RunAllExports()I tried the above script and the export contained two tabs, for was the table export and another one was the pivot.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerAltair Engineering-------------------------------------------------------------------------Original Message:Sent: 06-07-2020 05:44 PMFrom: Al RiceSubject: How to Export Pivot Table along with Table Data using COMHello All:I am using Monarch COM automation and need to write an VBA script How to Export Pivot Table along with Table Data. I have tried both EXPORTTABLE and JETEXPORTTABLE, as below, without success. The Table is exported, but not the Pivot Table.Option 1: EXPFILE = MonarchObj.EXPORTTABLE (ExportFolder & ARFILE)Option 2: EXPFILE = MonarchObj.JEXPORTTable(ExportFolder & ARFILE, ARTBBL, 0)Any help will be much appeciated.Thanks,------------------------------Al Rice------------------------------"
Hi Al,To export a Monarch Classic table to an Excel file with pivot, perform the following steps:Create an export in Monarch Classic,Save the model and the project file,you can run the project in the com object per following scripts:Make sure you add Monarch.exe to the Visual Studio project reference
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
