Coversheet Configuration
When defining the Microsoft Excel coversheet to be used in
an
AssetWise Package Distribution Order, you must
ensure the following:
- The configured coversheet is added to the File Container template
- Only OpenXML based Excel files (xlsx, Office 2007 and later) are supported for coversheets. Macro enabled files (.xlsm) are not supported.
- Formulas can be used within the sheet, but coversheet tags must remain in a separate cell.
- The value of coversheet
cells that must be populated must contain special tags:
- The tag format is
{object|value|filter}
- Tag start is denoted with a { and Tag end is denoted with a }
- Object is the source object. The following objects are supported:
- Value is the equivalent to an eQL statement
- Filter is the equivalent to an eQL statement, Where Clause, and is optional
- Each Tag component is separated by a | (vertical bar).
- There must be one Transmittal object, and one or more TransmittalItem objects.
- The TransmittalItem tags must be in the first row of a table. The system adds additional rows for each TransmittalItem.
- Special tag {Count} is used to populate the number of transmittal items in the coversheet.
- The tag format is