Use this procedure to create the XSLT template file needed for exporting a space evaluation to a Microsoft Excel spreadsheet.
You can use the following predefined field settings to format your XLT templates:
| Field name | Description |
|---|---|
| AREA_EVALUATION_BEGIN | The row in which the space evaluation begins |
| AREA_COLUMN_IMAGE | The column in which the exported space images are placed |
| AREA_COLUMN_LABEL | The column in which the space labels and descriptions are placed |
| AREA_COLUMN_EXPRESSION | The column in which the space decomposition expressions and modifier formulas are placed |
| AREA_COLUMN_RESULT | The column in which all space results are placed |
| AREA_COLUMN_EXACT_VALUE | The column in which the unrounded space results are placed |
- Open Microsoft Excel.
- Select the table cell in which you want to place a special type of information, such as pictures or results.
- Click the name box in the upper-left corner of the Excel sheet, and enter the desired field definition.
- Repeat steps 2 and 3 for all field settings you want to place.
- Define additional settings for your template. Settings in an XLT file include
- Header and footer information
- Company logos
- Company fonts
- Special cell formatting (borders, colors)
- Save the resulting file with the extension XLT (Excel Template) to the default directory you are using for templates.
The template is then available for selection next time you create a space evaluation.