Home
> EA
>
EA Excel Workshop
EA Excel
Data Transfer Workshop
NEW
This technical workshop teaches delegates how to transfer data between Enterprise Architect and Excel. Delegates learn to use CSV files and Visual Basic
code to synchronise element properties. This allows
data such as requirements to be manipulated both as a spreadsheet and
as a structured graphical model. |
 |
|
|
|
|
| Duration: |
1 or 2 days
|
|
| 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 and Microsoft Excel.
A trial version of
Enterprise Architect is fine for training purposes and
can be downloaded from Sparx Systems website:
www.sparxsystems.com/products/ea/trial.html
|
|
Workshop Style: |
25% theory, 75%
practical.
This workshop comprises a set of targeted hands-on
sessions to allow delegates to become confident
transferring data between Enterprise Architect and
Excel.
|
| Delegate Handouts: |
Each delegate receives a
booklet containing theory slides as well as a set of
exercises and suggested solutions. Following successful
completion of the workshop each delegate will receive a
certificate. |
|
|
|
|
|
Workshop Modules: |
HIPPO 00 |
Introduction |
½ hour |
|
|
|
|
|
|
|
| |
HIPPO W40 |
EA Excel Data
Transfer |
1 hour |
 |
 |
|
|
|
|
|
| |
|
EA Excel Data
Transfer Workshop |
5 hours |
|
|
|
|
|
|
 |
| Day 2
(Optional): |
Our trainer
can work with your delegates to assist them in applying their new skills to
write
Visual Basic code to transfer your own project data between Enterprise Architect
and Excel. |
Workshop Details:
|
|
|
|
| HIPPO 00 |
Introduction |
½ hour |
|
| |
|
| HIPPO W40 |
EA
Excel Data Transfer |
1 hour |
|
| |
|
| |
-
Use CSV files to
transfer data between EA and Excel
-
Add tagged values to elements in
EA
-
Write VB code to transfer data
between EA and Excel
|
|
|
| |
EA Excel Data Transfer Workshop |
5 hours |
|
| |
|
| |
-
Use CSV files to
transfer data from Excel to EA
-
Use CSV files to
transfer data from EA to Excel
-
Write VB code to connect Excel to EA via API
-
Add
tagged values to elements in EA
-
Write VB code to transfer data from Excel to EA
-
Write VB code to transfer data from EA to Excel
|
|
|
|
|
