🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Exporting Summary using .COM with Drill Up/Down Feature

User: "Al_22614"
Al_22614
Altair Community Member
Updated by Al_22614

Hello All:

Is it possible to Export a Summary to Excel using .COM automation with Drill Up/Down Feature invoked?  The Drill Up/Down Feature is good when the Excel file is large and the user may want to keep certain Key Groups collapsed.  See Screenshot below.

image
Many thanks




------------------------------
Al Rice
------------------------------

Find more posts tagged with

English
Monarch
Sort by:
1 - 1 of 11
    User: "Steve_Caiels"
    Steve_Caiels
    Altair Employee
    Updated by Steve_Caiels
    Hi Al,

    Yes - you should be able to enable this in all version of Monarch and export it using COM automation if you have the Automation enabled license.

    For version 15 and 2020 (I believe it is very similar for all versions after 10.5) . . .

    - Define your summary in the normal way
    - Go to the Export section and chose 'Export Design'.  
    - Go to the 'advanced' panel on the Excel Output settings
    - Select 'Include Outline to enable Drill Up/Down in Excel
    - Optionally, select your required drill state in the Summary View panel.
    - Save the Model (this contains the summary definition)
    - Save the Project (this contains the export definition)

    The project stores the export definition, including export types, paths, append/overwrite and formatting settings.  You can run the pre-defined export by opening the project in Monarch or using the Project version on the automation line (subject to license):

    To export all defined exports:
    "C:\Program Files\Altair Monarch 2020\Monarch.exe" /prj:"S:\My Projects\Sample.dprj" /PXALL

    To export a single defined export:
    "C:\Program Files\Altair Monarch 2020\Monarch.exe" /prj:"S:\My Projects\Sample.dprj" /PX:MyDefinedExportName

    Best regards,
    Steve.


    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-26-2020 06:10 PM
    From: Al Rice
    Subject: Exporting Summary using .COM with Drill Up/Down Feature

    Hello All:

    Is it possible to Export a Summary to Excel using .COM automation with Drill Up/Down Feature invoked?  The Drill Up/Down Feature is good when the Excel file is large and the user may want to keep certain Key Groups collapsed.  See Screenshot below.

    image
    Many thanks



    ------------------------------
    Al Rice
    ------------------------------
Quick Links