Creating Excel Template Worksheets

Common Features : Using the Repository : Exchanging Data with Excel : Creating Predefined Template Files (MEGA Windows Front-End) : Creating Excel Template Worksheets

An Excel template worksheet should define information required for creation of an Excel import/export worksheet.

For more details, see "Creating an Excel worksheet".

Information defined in columns of the Excel worksheet is Excel template data referenced by the system business document.

To create an Excel template worksheet:

1. Open the properties dialog box of the Excel template you want to attach to the worksheet.

2. In the Excel Worksheet section, click the New button.

3. In the properties of the Excel template worksheet you have created to specify a link type:

• In the MetaClass column, select the master MetaClass (for example "Application").

• In the MetaAssociationEnd column, select the MetaAssociationEnd (for example "Defined Service").

• In the Slave MetaClass column, select the slave MetaClass (for example "Application Service").

4. In the Macro section, click the Connect button to specify the macros that will be proposed by the wizard to fill the columns of the Excel export files.

For more details, see "Using Macros in Excel Import/Export Files".

5. Click OK to finish.