Defining Excel File Parameters
When export mode (new file or existing file) and file name have been defined, click Next.
The first step consists of defining Excel worksheets to be produced at export. These worksheets can be type:
• MetaClass (object list + characteristics)
• MetaAssociationEnd (links + link characteristics).
Two cases can be presented:
• If you run export from an existing file, worksheet default parameters are proposed.
• In the case of a new file, the dialog box is empty:
You will:
• create a worksheet for each object type (for example "Application"), and
• in the worksheets, create columns for each characteristic ("Name", "Comment", etc.).
Creating an Excel worksheet
To create a worksheet:
1. See Accessing the export wizard.
2. In the Excel export wizard dialog box, Excel Worksheet, click New 
.
.A worksheet appears.
3. Modify the name of the worksheet if necessary.
4. Indicate the object type it contains.
See Worksheet datatypes.Worksheet datatypes
In a worksheet you can define:
• a MetaClass, or
• a link type
To specify a MetaClass, for example an application:
1. Select the worksheet in question.
2. Click in the MetaClass column, then click on the arrow and select List MetaClasses.
The query dialog box appears.
3. Select the MetaClass and click OK.
Example: "Application".
To specify a link type:
1. Select the worksheet in question.
2. In the MetaClass column, select the master MetaClass.
Ex. "Application".
3. In the MetaAssociationEnd column, select the MetaAssociationEnd.
Example: "Service defined".
4. In the Slave MetaClass column, select the slave MetaClass.
Example: "IT Service".
When the link sends to a concrete MetaClass, the column of the slave MetaClass is completed automatically. When it sends to an abstract MetaClass, the list of concrete MetaClasses is proposed.Creating worksheet columns
Columns of an Excel worksheet specify attributes of the object defined in the Excel worksheet.
To create a column:
1. Select the Excel worksheet for which you wish to create a column.
2. In the Worksheet Column area, click the New button.
3. The column appears. Modify its name if required.
4. To indicate the attribute to be displayed in the column, click in the MetaAttribute/LegAttribute/Macro column and select List MetaAttribute/LegAttribute/Macro.
A dialog box lists MetaAttributes, LegAttributes and Macros available on the object type specified in the Excel worksheet. If the worksheet object type is a link, the dialog box lists the link attributes.
For more details on macros, see Using Macros in Excel Import/Export Files.5. Select a MetaAttribute and click OK.
Automatic name
When selected, the Automatic Name check box indicates that the file column takes the name of the MetaAttribute (for example "Short name"). If you clear this, the column takes the name indicated under Column ("Column 1").
Excel file configuration example
In the following example, the file contains three worksheets:
• the first worksheet contains applications
• the second worksheet contains links of "Defined Service" type between applications and services
• the third worksheet contains application services
For each application, the name, code, comment and type are displayed.
At this stage you can click the wizard Finish button. You obtain an export model which you can then complete.