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 for which you want to attach the sheet and select the Characteristics tab.
2. In the Excel Template worksheet, open the properties of the Excel Template worksheet of interest to you.
3. In the MetaClass field select the master MetaClass (for example "Application").
4. The fields MetaAssociationEnd and Slave Metaclass enable to fill in the column of an Excel worksheet with connected objects. For example, objects of the slave MetaClass “IT service” linked to the master MetaClass through the “Service defined” MetaAssociationEnd.
5. The Excel column macro enables to specify macros which will be run by the wizard to fill in each column of the Excel export worksheet.
For more details on used macros, see Using Macros in Excel Import/Export Files.6. Click OK to finish.