Enterprise Architect Excel Exporter allows users to export Model information as Excel documents.

Excel Exporter can be used to publish elements, connectors, tagged values, test cases, scenarios and various other model information, into Excel spreadsheets, for easy review and updates by the wider team.

Steps to Export EA Model Information to Excel:

Step 1: Select the EA Model that contains the information to be exported.

Step 2: Create/Choose the Specification for the EA Model to be exported.

Step 3:Create/Choose the Output document to be exported.

Step 4:Select the Worksheet from the output document to be exported.

Step 5:Generate the model elements in Enterprise Architect to Export the document.

Export Excel Profile

To Export data from EA Model, choose ‘Export to Excel’. The following dialog appears,

Select highlighted icon to create a new profile,

Home Tab

Mandatory Mappings:

Specify document to Export (Can use existing document or create new Excel document) using two nearby button icon.
Select the concerned work sheet from the dropdown or create a “New Work Sheet”

Optional Mappings:

Generate Headers: Select this option to Export properties along with column name.
Include Synchronization Information: Select this to Export Unique (GUID) information for every Object and Classifiers (Attributes and Methods).
Include Diagram Elements in Report: Select this and also select the appropriate diagram type’s in Diagram Tab, this will leads to include the element in the export from external Packages that are referenced in a diagram under each package.
Write Log File: It maintain, every Object Export Status.

Note: User can also export the data through unsaved profiles

Elements Tab

Model Data to be exported: All the properties are selected by default. User can,

Select/Unselect the properties.
Defined Tag Properties globally.
Create Custom Tag using “Add Custom Tag” button.

Types to be chosen for Exporting: All the Object types will be selected by default. User can,

Arrange the Order of export.
Select/Unselect the Object Types.

Note: Should select minimum one object type and Object properties to Export.

Stereotype to Export: Specifying stereotype filters the exporting elements.

All: Exports all the elements under the selected Object from Enterprise Architect.
Non-Stereotype: Objects without stereotypes are exported.
Specify Stereotype in CSV Format: User can define multiple stereotypes in CSV Format; the exporting objects must contain these stereotypes.
Prompt during Export: While starting Export, its pop-up the dialog, that shows all the stereotypes under the selected node from Enterprise Architect.

Attributes Tab

Selecting “Include Attributes” will enable “Export Settings” group.

Must select separate worksheet or choose to export in the Main Worksheet.

Select the attribute properties to export. Users can also define “Custom Tag” to include any additional tagged values defined in the model.

Methods Tab

Selecting “Include Method” will enable “Export Settings” group.

Must select separate worksheet or in Main Worksheet and select minimum one Method property to export. It also loads Global Tag, we can define “Custom Tag” also.

Test Scripts Tab

Selecting “Include TestScript” will enable “Export Settings” group.

Must select separate worksheet or in Main Worksheet and select minimum one TestScript property to export.

Glossary Tab

Selecting “Include Glossary” will enable “Export Settings” group.

Select Worksheet to export Glossary and also select minimum one property to export.

Diagram Type Tab

It is used to export all the objects available in diagram, irrespective of objects available under selected node. We must select “Include Diagram Elements in Report” in Home Tab and also select suitable diagram type to export the objects.

Connector Tab

Context End: Used to define the settings of one end of connector.

Column Name: The name is connector column name, which will be displayed in the generated Excel document.
Context End: Select the element type for one end of the connector.
Delimited By: Exporting the Object Name into the corresponding Connector Column in Excel should be separated by this delimited value.

Other End: Used to define the settings of another end of the connector,

Type: Select the element type for another end of connector.
Stereotype: It defines the stereotype for the other end of the connector.it support CSV Format.it filter out the connector to Export.
Value: It used to search, that which type of the property should match the connectors that needs to be exported.

Connector: Used to define connector settings,

Direction: Specify direction of the connector.
Stereotype: It defines connector Stereotypes
Type: It defines type of Connector

Note: Except Stereotype input, all other inputs are mandatory!!!

Export Process

While selecting Export button, two options will be displayed.

To Local System: Allows user to export document to the local system.
To SharePoint: Allows user to export document to the SharePoint folder. For more information regarding SharePoint export, refer “C:\ProgramData\MDG Integration for Microsoft Office\Help Document\UserGuide\index.html”

It gives a pop-up, like

Prompt during Export option, will prompt here, it shows all the object stereotypes available under selected Node from Enterprise Architect

Select Export, to export non-stereotyped Object.

Exported Document

Elements are exported with GUID information.

Attributes are exported with GUID information and parent object information under “GUID” and “ELEMENT NAME” column, respectively, which is highlighted.

Methods are exported with GUID information and parent object information under “GUID” and “ELEMENT NAME” column, respectively, which is highlighted.

TestScripts are exported with Parent object information in “ELEMENT NAME” column, which is highlighted.
Glossary Exported with Term, Type and Meaning column. It is Model defined.
Connector Column Exported
Scenarios are exported with GUID information and parent object information under “GUID” and “ELEMENT NAME” column, respectively, which is highlighted.
Constraints are exported with Parent object information in “ELEMENT NAME” column, which is highlighted.
Export profile has
Description: Want to export Connector Other end Name. It has to filter out the connector ends while exporting,
- Source and Destination are Usecase type.
- Connector Type should be “Dependency”.
- Connector Direction should be “Incoming”.
Comparing results,
- “Login” has Incoming Connector from “Create Account” of “Dependency” Type.
- “View Account Details” has Incoming Connector from “Close Account” of “Dependency” Type.
- “Close Account” has Incoming Connector from “Delete User” of “Dependency” Type.
Connector Other End names are exported successfully!

Above,section Examine Overall Export Process.

21 Comments

MarygenJanuary 2, 2024 at 8:21 pm

cheap propecia no prescription
IvygenJanuary 4, 2024 at 2:50 am

bactrim cream generic
LloydkabJanuary 5, 2024 at 2:59 pm

SMM Panel – Social Media Services, SMM Panel API
JosephtreptJanuary 6, 2024 at 10:58 am

browse around this web-site WhatsApp web
IvygenJanuary 6, 2024 at 2:09 pm

how to buy azithromycin
DarrylSwaMyJanuary 10, 2024 at 7:31 pm

where to buy fildena
DavidcalJanuary 11, 2024 at 7:13 pm

Феникс 1-16 серии смотреть онлайн Это история о любви, о предательстве, о мести. Иногда судьба ставит нас перед выбором, последствия того или иного решения могут изменить самым кардинальным образом жизнь того, кто сделал выбор. В итоге меняется все – приоритеты, мысли, цель… Меняется все вокруг! Кто-то одобряет человека, сделавшего выбор, кто-то осуждает…Есть ли золотая середина? Практически все герои этой истории двуликие, практически у каждого есть светлая и темная сторона личности, у каждого припрятаны «скелеты» в шкафу. Сюжет трагический, словно в древнегреческой трагедии. Но, быть может, для главного героя финал этой истории обернется не трагедией, а новым, счастливым витком его жизни, хотя, как знать… События разворачиваются в небольшом городке под названием Кировск. Главного героя зовут Иван Колесников. Он мало чем отличается от других жителей Кировска. Тихий, мирный человек. Очень любит свою очень красивую жену.
CurtisgenJanuary 12, 2024 at 1:54 pm

toradol pill cost
Rastrear Teléfono CelularFebruary 8, 2024 at 1:03 am

Rastreador de teléfono celular – Aplicación de rastreo oculta que registra la ubicación, SMS, audio de llamadas, WhatsApp, Facebook, fotos, cámaras, actividad de Internet. Lo mejor para el control parental y la supervisión de empleados. Rastrear Teléfono Celular Gratis – Programa de Monitoreo en Línea.
Rastrear teléfonoFebruary 10, 2024 at 2:57 pm

La mejor aplicación de control parental para proteger a sus hijos – monitoriza en secreto GPS, SMS, llamadas, WhatsApp, Facebook, ubicación. Puede monitorear de forma remota las actividades del teléfono móvil después de descargar e instalar apk en el teléfono de destino.
e-commerceMarch 21, 2024 at 10:48 pm

Wow, marvelous blog layout! How lengthy have you ever been blogging for?
you make blogging glance easy. The whole glance of your web site is excellent, let alone the
content! You can see similar here najlepszy sklep
sklepMarch 21, 2024 at 11:50 pm

Wow, amazing weblog layout! How lengthy have you been blogging for?
you make blogging look easy. The whole look
of your site is wonderful, as neatly as the content material!
You can see similar here sklep internetowy
sklep onlineMarch 22, 2024 at 6:31 am

Incredible points. Outstanding arguments. Keep up the amazing work.

I saw similar here: E-commerce
vortexara.topMarch 24, 2024 at 5:26 pm

Wow, superb weblog structure! How long have you been blogging
for? you made running a blog look easy. The total glance of your website is excellent, as smartly as the content material!
You can see similar here sklep internetowy
Analytics & social researchMarch 24, 2024 at 7:49 pm

It’s very interesting! If you need help, look here: ARA Agency
binance us registraceMarch 27, 2024 at 10:20 pm

Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
dobry sklepMarch 28, 2024 at 2:54 am

Hi there! Do you know if they make any plugins to assist with
Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m
not seeing very good success. If you know of
any please share. Thanks! You can read similar text here: Najlepszy sklep
Scrapebox ListApril 3, 2024 at 1:03 pm

Hi there! Do you know if they make any plugins to help with SEO?
I’m trying to get my website to rank for some targeted keywords but I’m
not seeing very good results. If you know of any please share.
Many thanks! I saw similar art here: Backlinks List
Backlink PortfolioApril 6, 2024 at 4:14 am

Hello! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying
to get my website to rank for some targeted keywords but I’m not seeing very good success.
If you know of any please share. Thanks! You can read similar text here: Scrapebox AA List
34.01hv6zg5faa7r9bctrx7tq8fma@mail5u.xyzApril 12, 2024 at 11:55 am

et omnis debitis quae non sapiente. sunt voluptatem aut aut fugit nemo distinctio et velit consectetur culpa. deserunt vel deserunt consequatur odit architecto perspiciatis est quis explicabo sequi qu
sklep internetowyApril 16, 2024 at 3:07 am

Wow, fantastic weblog format! How lengthy have you been blogging for?
you made blogging look easy. The overall glance of your web site is great, as smartly as the content material!
You can see similar here dobry sklep

Blog Post

Enterprise Architect Export Excel