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.
Delegates should have a
working knowledge of Enterprise Architect.
Some basic programming experience is also helpful, but
For on-site delivery the customer should provide
a suitable training room with a screen or projector to connect to
our trainer's laptop and a whiteboard or flipchart.
delegates require a PC or laptop running
(corporate edition or higher) and MS Excel.
For webinar delivery delegates require a
PC or laptop running Enterprise Architect with an
Internet connection (a headset can be helpful). If you
wish to test your environment join a test WebEx meeting:
A trial version of Enterprise Architect is fine for training
and can be downloaded from Sparx Systems
It is also helpful to have a mouse as this makes
creating diagrams much easier.
30% theory, 70%
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
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