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
- Import an Excel document using the profile defined for the respective worksheet
- Check ‘Enable Synchronization’ in the Importer dialog
- You will be prompted with the following dialog
- You can request EA to write sync data into the original file that is imported
- Or write the synch data to a backup file (which will then become your master copy in which subsequent changes must be done)
- Once you choose the backup file path and synch settings, click Apply
- Click Preview and Import in the Importer dialog
- Upon successful completion of import, the synch data will be added to the output file
- Make changes to the synchronization file (where the Synch information has been written)
- The Synchronization file, which becomes your masterfile, must be reimported using the same steps as above to ensure the contents are synchronized.
- You will notice that the EA artifacts are ‘Updated’ instead of ‘Added’
