Home
> EA
>
EA Excel Workshop
EA Excel
Data Transfer Workshop
Updated
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 (Corporate edition
or higher) 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 all the workshop slides and
comprehensive theory notes which form excellent
reference material. A set of exercises and suggested
solutions are also provided. Following successful
completion of the workshop each delegate will receive a
certificate. |
|
|
|
|
|
Workshop Modules: |
HIPPO 00 |
Introduction |
½ hour |
|
|
|
|
|
| |
HIPPO W41 |
EA Excel CSV Workshop |
2½ hours |
|
 |
|
|
 |
| |
HIPPO W42 |
EA Excel Script Workshop |
3½ 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 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 W42 |
EA Excel Script Workshop |
3½ hours |
|
| |
|
| |
-
Write VB code to connect Excel to EA via API
-
Write VB code to transfer data from Excel to EA
-
Write VB code to transfer data from EA to Excel
|
|
|
|
|
