Displaying items by tag: export excel

Monday, 06 June 2016 01:59

Excel Requirement bridge

Enterprise Architect provides many features for requirements management. It allows team to create and update requirements, trace their solution, maintain whole requirement life cycle.

We need sometimes work with requirements “outside” the Enterprise Architect. Especially when we discuss them with customers. We can of course generate documents from RTF templates as basis for meeting, which is suitable for most cases. At the level of project management, when it comes to project scope and overall state of requirements, is better to have requirement list in form of an Excel spreadsheet. Project manager can clear report requirement status to the customer and quickly change the list according to the results of the meeting. Next step is to save changed list back to Enterprise Architect.

We tried package CSV Import/Export utility but it was not suitable for us. CSV format is prone to data errors and we needed to split some data cells into more requirement properties.


So we decided to write our own bridge for requirement data interchange between Excel spreadsheet and Enterprise architect repository.


Our Excel requirements template has several columns. Mapping to requirement attributes is as follows:


Requirement attribute


Requirement code – first part of requirement name before “-“


Package path to requirement in repository


Tagged value “REQ: Source”




Tagged value “REQ: Date discovered”









The bridge is implemented as Excel addin. It is written in Visual Basic and stored in Requirements.xlam file. When you add it to Excel, new tab CCA appears in ribbon. It has two commands “to Excel” for importing requirements from Enterprise architect repository to Excel spreadsheet and “to EA” for saving requirements from Excel back to EAP.


Importing requirements to Excel

Bridge is written for requirements template MyProjectREQ.xlsm. Copy it into new file and open this file. Press “to Excel”.

File open dialog appears, choose your project EAP file. Program then show “Enter prefix” dialog to filter imported attributes. Enter the prefix (for example “REQ”) or leave the value empty for all requirements. Program uses standard Enterprise Architect search “Requirements”.

Sheet is filled with requirements. Notice the cell D3 – it contains EAP filename. When you run command “to Excel” again, you will be not asked for EAP file name, the file in cell will be used. The same applies for saving cells back to Enterprise Architect.

Column “J” is hidden – it contains requirement GUIDs for subsequent updates.


Saving requirements to Enterprise Architect

After you made changes in requirement list in your spreadsheet, you can save them directly to project EAP file. Press “to EA”.

Program shows dialog with EAP package structure. Choose your requirements root package. New requirements (requirements without GIUD) will be inserted into this package.


Saving starts immediately after your select the package.


Data transformations

In our Excel template we use ID and Description for requirement code and description. In Enterprise architect we use Requirement name and notes. Enterprise architect has an alias attribute, which can store requirement code, but it is not useful, because we have to see this code in Project browser. So we have to transform




Must be recoverable quickly.

In the event of software or hardware failure the system must be able to be recovered to full operating mode within the tolerances listed below. In the event of parts of the system failing the system must be able to be run in a safe mode.




REQ113 - Must be recoverable quickly.

Must be recoverable quickly.

In the event of software or hardware failure the system must be able to be recovered to full operating mode within the tolerances listed below. In the event of parts of the system failing the system must be able to be run in a safe mode.


This is done using simple VBA functions. Code is delimited by “-“ character. Requirement name is derived from first sentence in description.



This article is mentioned as other example of extending Enterprise architect. It is a real life example, we use it in our company for many projects.

If it is suitable for you, use it! Any comments are welcome!

Petr Přibyl

CCA Group a.s.

This email address is being protected from spambots. You need JavaScript enabled to view it.

Published in Community Resources

MDG Office Integration for excel supports the following

Import from Excel 

  • Importing artifacts from MS Excel documents
  • Synchronizing subsequent changes (additions, modifications) from the MS Excel document into EA 

Export to Excel

  • Export Enterprise Architect contents into a (pre-formatted) Excel spreadsheet

Please follow the following steps to try synchronization

  1. Import an Excel document using the profile defined for the respective worksheet
  2. Check ‘Enable Synchronization’ in the Importer dialog

  1. You will be prompted with the following dialog
    1. You can request EA to write sync data into the original file that is imported
    2. Or write the synch data to a backup file (which will then become your master copy in which subsequent changes must be done)
  2. Once you choose the backup file path and synch settings, click Apply

  1. Click Preview and Import in the Importer dialog
  2. Upon successful completion of import, the synch data will be added to the output file

  1. Make changes to the synchronization file (where the Synch information has been written)
  2. The Synchronization file, which becomes your masterfile, must be reimported using the same steps as above to ensure the contents are synchronized.
  3. You will notice that the EA artifacts are ‘Updated’ instead of ‘Added’

Published in Tutorials