EA Excel import-export

(4 customer reviews)

0,00 Exl. VAT

The EA Excel import-export tool can be used to export and import between Sparx Enterprise Architect and Excel. Using only an Excel file, and the built in macro’s you can use it to

  • Export and Import element and attribute data (including tagged values on elements and attributes)
  • Import the Glossary
  • Export and Import tagged values

Description

 

The EA Excel import-export tool can be used to export and import between Sparx Enterprise Architect and Excel. Using only an Excel file, and the built in macro’s you can use it to

  • Export and Import element and attribute data (including tagged values on elements and attributes)
  • Import the Glossary
  • Export and Import tagged values

For more info see EA Excel Importer-Export

Version 5.0

Version 5.0 adds a complete new import and export feature for elements and attributes.

  • Configure exactly what you would like to export using an SQL Query
  • Use GUID’s of elements and attributes to update items regardless of their location in the model
  • Define whether to create, update, or delete items using the Action column
  • Specify a datatypes package and link attribute types with the datatypes in the datatype package
  • Support for a lot more fields such as alias, version, status, initial value etc.
  • Export and import formatted notes (limited to bold, italic and underline)
  • Import and export any tagged values you define on elements and attributes.

4 reviews for EA Excel import-export

  1. David McGuffin (verified owner)

    Thank you for producing this useful resource. I have used your Simple VBA Excel to EA importer before. Are you planning on creating any instructions on how to use this new tool?

  2. Mo (verified owner)

    Thank you, Geert. This is a great tool!
    It became an integral part of my interaction with EA.

  3. Sylvain

    Hi Geert,

    Thank you for this tool. It is working as expected on EA 13. I’m starting to migrate to EA15.2 so I’m testing my previous scripts/add-in before… Unfortunatelly, the EA Excel Import-Export is not working anymore : “execution error 429, an ActiveX component can not create an object” : Set parentPackage = eaConn.getSelectedPackage(); Did someone have the same issue ?

    • Geert Bellekens

      You might need to re-link EA’s API using the references in the VBA editor

  4. Sylvain

    Hi Geert, Thank you for the answer., but what to you mean by re-link EA’s API ? Checking that operations/functions did not change between the two versions ?

    Concretely, the execution error is here :
    Dim EAapp As EA.App
    Dim EArepository As EA.Repository
    On Error Resume Next
    Set EAapp = GetObject(, “EA.App”)

    in VBA, references are enabled, I have access to all the EA functions/object pressing F2…
    I removed all previous references in the registry, performed a fresh installation, still not working with version 15.2.
    A have a copy of the EA 13.5’s folder before the upgrade to 15.2, just launching the ea.exe and using the toolbox/dll from the 15.2 and it works !
    Just testing Sparx example doesn’t work… so I opened an issue…

    • Geert Bellekens

      Go to the VBA editor (Alt-11) and then Tools | References and make sure the Enterprise Architect Object Model is checked. Possibly uncheck it and check it again.

Add a review

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.