Enterprise Architect, BPMN, UML, SysML and ArchiMate
Home EA BPMN UML SysML ArchiMate Feedback Resources Pricing Partners Contact
 Home > EA > EA Excel Data Transfer Workshop
 

EA Excel Data Transfer Workshop

This workshop teaches delegates how to transfer data between Enterprise Architect and MS Excel. Delegates use CSV files and VBScript to synchronise data. This allows information such as a set of requirements or data model to be updated either as a spreadsheet or graphical model.
Duration: 1 day
 

 

Prerequisites: Delegates should have a working knowledge of Enterprise Architect.
Some basic programming experience is also helpful, but not essential.
 
Equipment:

This workshop is delivered on the customer's own site. The customer should provide a suitable training room with a projector to connect to our trainer's laptop and a whiteboard or flipchart. All delegates require access to a PC or laptop running Enterprise Architect (corporate edition or higher) and Microsoft Excel.

A trial version of Enterprise Architect is fine for training and can be downloaded from Sparx Systems website: www.sparxsystems.com/products/ea/trial.html 
 
Workshop Style: 20% theory, 80% practical.
This workshop comprises a set of targeted hands-on exercises to allow delegates to become confident using CSV and scripts to transfer data between Enterprise Architect and MS Excel.
 
Delegate Handouts: Each delegate receives a booklet containing all the workshop slides and comprehensive theory notes which form excellent reference material. Booklets also contain exercises and suggested solutions. Following successful completion of the workshop each delegate receives a certificate.
Module Key: Teaches concepts and notation

  Teaches practical use of Enterprise Architect
             Covers BPMN, UML, SysML and/or ArchiMate

Download
Course Outline

      Includes paper exercises, EA hands-on sessions

Workshop Modules: HIPPO 00    Introduction   hour          
  HIPPO W41  EA Excel CSV Workshop  2 hours      
  HIPPO W43  EA Excel Scripting Workshop  5 hours      


Workshop Details:
 

HIPPO 00  Introduction   hour  
 
  • Delegate background and objectives

  • Timetable and workshop outline


HIPPO W41  EA Excel CSV Workshop  2 hours
 
 
  • Use CSV to transfer data from Excel to EA

  • Use CSV to transfer data from EA to Excel

  • Use CSV to transfer tagged values

 
HIPPO W43  EA Excel Scripting Workshop  5 hours
      
 
  • Write scripts to connect Excel to EA via API

  • Write scripts to transfer data from Excel to EA

  • Write scripts to transfer data from EA to Excel

  • Extend scripts to transfer tagged values

  • Synchronise EA elements with Excel

hippo@hippo-software.co.uk

+44 (0)1506 202164

    Hippo Software Limited 2015. All registered trademarks acknowledged.